Recent content by Delphiwhat

Hi Mufasa The two tables are totally independent. No relationships. The original text is what I need a trigger to do, Upon insertion into tableA ..... check if tableA.user_id exists in tableB.userid and if an entry is found delete the row found in tableB I know it sounds strange but...

Guys another quick one. Being a none Oracle person I'm getting stuck on the basics..... 1 problem.... User details are inserted into a Table called 'users'. A table called 'Users_stats' holds other information about the client. When a row is inserted into the 'users' table I need to check...

BJ hope you don't mind just another quick one. Being a none Oracle person I'm getting stuck on the basics..... 1 problem.... User details are inserted into a Table called 'users'. A table called 'Users_stats' holds other information about the client. When a row is inserted into the 'users'...

Thanks BJCooperIT you are a star. Helped me out big time. steve

hi guys Can someone help me out with some (basic i guess) I want to create an on-delete trigger on table 1 that when a row is deleted on table 1 the row data is captured on table 2 before the row is successfully deleted. any ideas Thanks in advance steve

thanks!!! :)

Folks I've a 6X16 Norstar and a startalk mini rel02c . Never installed one of these nortel system before but woul dlike to try this just for the experience. Would anyone know where I could obtain installation and programming manuals for this kit? thanks steve

An external application is populating Table x I am basically looking for the order number that has just been populated in table x for existance in table y. If it exists do nothing otherwise delete the row that is applicable to the current order no. with respect to design I am working with...

Hi all I have a table (table X) which holds order numbers. When a row is inserted into table X I go and find data in another table Y using the order number. I need a trigger that.... If the data is found in table Y then nothing happens else If data is not found in table Y then the...

Cheers Mufasa for your help - worked a treat Your a life saver!! You don't by chance know how to send an email notification without UTL_SMTP? Thanks jscter

Hi all Does anyone know how I cam log the ddms_output to a file ( I need to be able to save the file for debug purposes. unfortunately the UTL_FILE package is not installed on the oracle server. Thanks!! jscter

Hi all Does anyone know or point me in the right direction on how to send email ( i want to send an email notification on error) without using the UTL_SMTP package, Many thanks jscter

Guys I don't know if this is the correct form to ask this but i couldn't find a PL/SQL one! so maybe someone can help. What I am trying to do is retrieve data from a VIEW and update this data into another TABLE. When I have got this working manually i will need to CRON it as an automated...

Guys I just cracked open my 8200 Phaser to replace the lamps but have stumbled across a problem.... I'm in Great Britain (240v ac) but the lamps that I have taken out of the machine are 120v ac 150W (4 11/16") I cannot get 150W lamps over here that are 120v or the right size. I seen lamps...

Hi all Is there a quick way of displaying the memory usage of my pb application. I want to display the memory it is using in a single line edit Any ideas? thanks in advance S