OraFAQ Forum: SQL & PL/SQL » Difference between DO_KEY('Execute_query') and Execute

Home » SQL & PL/SQL » SQL & PL/SQL » Difference between DO_KEY('Execute_query') and Execute_query

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Difference between DO_KEY('Execute_query') and Execute_query [message #6930]

Mon, 12 May 2003 03:56

Jayasri
Messages: 28
Registered: July 2000

Junior Member

Hi,
Could you please tell me what is the difference between DO_KEY('Execute_query') and Execute_query.

Regards
Jayasri.

Report message to a moderator

Re: Difference between DO_KEY('Execute_query') and Execute_query [message #6969 is a reply to message #6930]

Wed, 14 May 2003 03:14

Martin Chadderton
Messages: 35
Registered: May 2003

Member

Hi Jayasri,

DO_KEY('EXECUTE_QUERY') will do the same thing as if the user has pressed the key to execute the query, (usually meaning firing KEY-EXEQRY trigger etc.), whereas EXECUTE_QUERY; will literally just execute the query.

Regards
Martin.

Report message to a moderator

Re: Difference between DO_KEY('Execute_query') and Execute_query [message #7003 is a reply to message #6969]

Thu, 15 May 2003 00:07

Jayasri
Messages: 28
Registered: July 2000

Junior Member

Hi Martin,
Thanks for the info.

Regards
Jayasri.

Report message to a moderator

Previous Topic:	Transaction Isolation_level=Serializable
Next Topic:	how many concurrent users??

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 22:34:31 CDT 2024