Home » SQL & PL/SQL » SQL & PL/SQL » About Trigger
About Trigger [message #213746] Fri, 12 January 2007 03:04 Go to next message
romi
Messages: 67
Registered: October 2006
Member

Hello All,

I want to know uses of trigger.Why we use trigger,plz explain me with a example.

I have knowledge that we can do all thing in GUI which we do by trigger, than why we use trigger?

If anyone knows then plz explain me with example.It's very-2 important for me.


Thanks

Report message to a moderator

Re: About Trigger [message #213752 is a reply to message #213746] Fri, 12 January 2007 03:40 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member
READ

Report message to a moderator

Re: About Trigger [message #213769 is a reply to message #213752] Fri, 12 January 2007 04:26 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Quote:
we can do all thing in GUI which we do by trigger

/forum/fa/1600/0/

Report message to a moderator

Re: About Trigger [message #213771 is a reply to message #213769] Fri, 12 January 2007 04:31 Go to previous messageGo to next message
romi
Messages: 67
Registered: October 2006
Member

Thanks littlefoot,

If we can do all thing by GUI,Then what is the use of trigger.Why we use trigger in PL-SQL.Plzzzzzzzzzzzzzzz explain me?

Thanks

Report message to a moderator

Re: About Trigger [message #213780 is a reply to message #213771] Fri, 12 January 2007 04:56 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member
I guess you dont understand Littlefoot's smiley

Report message to a moderator

Re: About Trigger [message #213782 is a reply to message #213746] Fri, 12 January 2007 05:03 Go to previous messageGo to next message
romi
Messages: 67
Registered: October 2006
Member

Yes tahpush, I couldn't understand littlefoot smiley.Do u know the answer of my question?

Report message to a moderator

Re: About Trigger [message #213783 is a reply to message #213782] Fri, 12 January 2007 05:06 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
We will almost certainly be able to answer your question when we understand what you mean by:
Quote:
I have knowledge that we can do all thing in GUI which we do by trigger, than why we use trigger?


In general, a database trigger (which @tahpush has already pointed you to a good explanation of) is used to automatically perform actions on data when it is modified.

Report message to a moderator

Re: About Trigger [message #213784 is a reply to message #213746] Fri, 12 January 2007 05:18 Go to previous messageGo to next message
romi
Messages: 67
Registered: October 2006
Member

I simply wanted to know that, what is the use of trigger in pl-sql? why we use trigger.That's all.

Report message to a moderator

Re: About Trigger [message #213786 is a reply to message #213746] Fri, 12 January 2007 05:23 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member
Well I gave you a link that explains trigger very well.

Also JRowbottom said that
Quote:
is used to automatically perform actions on data when it is modified.


What more do you need to know ?

If there is something specifik you dont understand about triggers, then specify that.

Report message to a moderator

Re: About Trigger [message #213793 is a reply to message #213786] Fri, 12 January 2007 05:45 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Otherwise, use of a trigger is that when you pull it, a gun shots.

Just kidding! GUI is a lovely thing, that is true, but I wouldn't agree that it can do everything, just like a trigger. How would you, for example, solve a mutating table error using your preferred GUI?

Report message to a moderator

Re: About Trigger [message #213810 is a reply to message #213793] Fri, 12 January 2007 06:57 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Or how would you use a GUI to ensure that no matter what tool the user used, their changes to a table would be logged?

Report message to a moderator

Previous Topic: How to create sub independent Transaction?
Next Topic: How do I find a gap in sequence?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Dec 07 01:51:28 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.