OraFAQ Forum: SQL & PL/SQL » How does DBMS_SQL differ from Native Dynamic Code

Home » SQL & PL/SQL » SQL & PL/SQL » How does DBMS_SQL differ from Native Dynamic Code

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

How does DBMS_SQL differ from Native Dynamic Code [message #563460]

Mon, 13 August 2012 23:34

Jana.A
Messages: 8
Registered: August 2012
Location: Coimbatore

Junior Member

Hi,

Let me the difference between the DBMS_SQL and Execute immediate .
*) Which one is faster ?
*) Where to use DBMS_SQL and Execute immediate (correct usage of both)?
Please help me regarding this.

Thanks,
Jana

Report message to a moderator

Re: How does DBMS_SQL differ from Native Dynamic Code [message #563463 is a reply to message #563460]

Tue, 14 August 2012 01:17

flyboy
Messages: 1673
Registered: November 2006

Senior Member

Hi,

fortunately, answer to your questions is written in Oracle documentation, which is available e.g. online on http://tahiti.oracle.com/

For 11gR2, you may be interested in these chapters:
EXECUTE IMMEDIATE: http://docs.oracle.com/cd/E11882_01/appdev.112/e25519/dynamic.htm#CACDDACH
DBMS_SQL: http://docs.oracle.com/cd/E11882_01/appdev.112/e25788/d_sql.htm#BABEDAHF

Just one recommendation: use dynamic SQL only when the task cannot be achieved by static SQL, as it (static SQL) is most performant.

Report message to a moderator