Home » SQL & PL/SQL » SQL & PL/SQL » sql help
sql help [message #223297] Thu, 08 March 2007 06:25 Go to next message
pavuluri
Messages: 247
Registered: January 2007
Senior Member
simple qua
simple what is main difference tiger and procedure
thanks
srinivas
Re: sql help [message #223299 is a reply to message #223297] Thu, 08 March 2007 06:43 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
pavuluri wrote on Thu, 08 March 2007 13:25
simple qua
qua = question?
pavuluri wrote on Thu, 08 March 2007 13:25
simple what is main difference tiger and procedure
tiger? What the hell are you talking about?

MHE
Re: sql help [message #223313 is a reply to message #223297] Thu, 08 March 2007 07:42 Go to previous messageGo to next message
martijn
Messages: 283
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 #223327 is a reply to message #223313] Thu, 08 March 2007 08:04 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Martijn said
assuming you mean question (qua) and trigger (tiger) I would say


w00t!
We have a new Crystal Ball viewer ./fa/1659/0/

Good one Martijn!
Re: sql help [message #223329 is a reply to message #223327] Thu, 08 March 2007 08:07 Go to previous messageGo to next message
martijn
Messages: 283
Registered: December 2006
Location: Netherlands
Senior Member
Just trying to be friendly Smile

Anyway ... I hope my answer was somewher near the truth.
Re: sql help [message #224508 is a reply to message #223297] Wed, 14 March 2007 08:31 Go to previous message
joy_division
Messages: 4640
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

Previous Topic: procedure accept insert into query as parameter
Next Topic: Master Details Trigger problem in 10g XE App Express
Goto Forum:
  


Current Time: Tue Dec 06 04:08:50 CST 2016

Total time taken to generate the page: 0.11162 seconds