| sql help [message #223297] |
Thu, 08 March 2007 06:25  |
pavuluri
Messages: 247
Registered: January 2007
|
Senior Member |
|
|
simple qua
simple what is main difference tiger and procedure
thanks
srinivas
|
|
|
|
|
|
| Re: sql help [message #223313 is a reply to message #223297] |
Thu, 08 March 2007 07:42  |
martijn
Messages: 286
Registered: December 2006
Location: Netherlands
|
Senior Member |
|
|
assuming you mean question (qua) and trigger (tiger) I would say:
A procedure is a peace of code which can do a variety of things. You can call a procedure whenever you need the functionality in the procedure.
A trigger is a special peace of code wich is executed when a certain event takes place. For instance an "before insert" trigger is executed just before a row is added to a table.
For a more comprehensive explanation I like to point you to the extensice (and free) documentation on various sites.
|
|
|
|
|
|
|
|
| Re: sql help [message #224508 is a reply to message #223297] |
Wed, 14 March 2007 08:31 |
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
|
Senior Member |
|
|
| pavuluri wrote on Thu, 08 March 2007 07:25 | simple qua
simple what is main difference tiger and procedure
thanks
srinivas
|
It's like comparing apples to emotions.
A tiger is a mammal, in the feline family I believe.
A procedure (in Oracle) can be found in the PL/SQL User's Guide and Reference. Too much to get into here.
[Updated on: Wed, 14 March 2007 08:31] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
