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
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
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: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Quote:
we can do all thing in GUI which we do by trigger

./fa/1600/0/
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
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
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?
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.
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.
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.
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: 20901
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?
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?
Previous Topic: How to create sub independent Transaction?
Next Topic: How do I find a gap in sequence?
Goto Forum:
  


Current Time: Thu Dec 08 19:53:57 CST 2016

Total time taken to generate the page: 0.08697 seconds