triggers [message #9322] |
Tue, 04 November 2003 04:20 |
vandna
Messages: 7 Registered: November 2003
|
Junior Member |
|
|
1.is there any version of oracle9i along with d2k that can be installed on a stand alone pc 128mb ram 1.6 mhzproc,40gb hd.
2. want to know abot diff triggers(applied)
|
|
|
|
Re: triggers [message #9332 is a reply to message #9322] |
Wed, 05 November 2003 02:28 |
William Robertson
Messages: 1643 Registered: August 2003 Location: London, UK
|
Senior Member |
|
|
> 2. want to know abot diff triggers(applied)
Can you be a bit more specific? What do you want the triggers to do?
"The wonderful thing about triggers,
is triggers are wonderful things."
|
|
|
Re: triggers [message #9360 is a reply to message #9332] |
Thu, 06 November 2003 00:42 |
vandna
Messages: 7 Registered: November 2003
|
Junior Member |
|
|
hello
thanks for replying.
i want to know the following things about the triggers.
1.what exactly are triggers?how and when do they get executed?whrer exetacly they are being used(application area).
2. if triggers are also a stred piece of code then what is the difeerence between stored procedure, precompiled sql.(besides being them getting executed on their own)
3.are triggers of pl/sqldifferent from that used in the D2k?if yes how.
3.how the security of the forms and the database is controlled via triggers.
4. can triggers also convert the data in a form that the information remains hiddenmeans encryption/dcryption.
thanks
regards
vandna
|
|
|
Re: triggers [message #9422 is a reply to message #9360] |
Mon, 10 November 2003 01:41 |
Rij
Messages: 12 Registered: September 2003
|
Junior Member |
|
|
May be i can help u..
1. Triggers are pice of code that get executed implicitly when a DML statement gets executed. They fire ta the bac-end .
2. DIff between triggers and stored procedure ios that u need to invoke a stored procedure but triggers are executed automatically on execution of a dml statement like insert update and delete.
3. Yes they are diffe from D2K triggers in the sense that d2k triggers fire at front -end on pressing of an button, clicking fo a button , while navigation. also u cannot write commit in a database trigger.
4. u can prevent deletion of a row using triggers or prevent updation of a column .
Hope u get some clarity
|
|
|
|