OraFAQ Forum: Forms » help with trigger

Home » Developer & Programmer » Forms » help with trigger

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

help with trigger [message #424021]

Tue, 29 September 2009 23:00

rad1cal
Messages: 2
Registered: September 2009

Junior Member

i'm only new to oracle and i want to make a trigger that will check the value of a textfield or will ask for a password before it will delete a row.
for example, i want to delete a transaction from transaction table but i will be ask to enter a password before i can delete the row..

thanks in advance.

Report message to a moderator

Re: help with trigger [message #424028 is a reply to message #424021]

Tue, 29 September 2009 23:54

shaz
Messages: 182
Registered: June 2009

Senior Member

Quote:

i want to make a trigger that will check the value of a textfield

Use when validate item trigger.

Quote:

i want to delete a transaction from transaction table but i will be ask to enter a password before i can delete the row

Use On delete trigger.

Report message to a moderator

Re: help with trigger [message #424029 is a reply to message #424028]

Wed, 30 September 2009 00:00

shaz
Messages: 182
Registered: June 2009

Senior Member

I would like to advise you to read about all the triggers. There is a inbuilt help library and apart from it, there is a lot of reading stuff available on the net.

Report message to a moderator