Oracle Discussion Forums
Welcome, Guest. Please login or register.
September 10, 2010
Home Help Search Login Register
News:


+  WebForums - OraclePassport
|-+  IT progamming - Oracle, Java, Unix, MySQL, Toad
| |-+  Oracle PL/SQL Questions
| | |-+  Native Dynamic SQL and DBMS_SQL		 0 Members and 1 Guest are viewing this topic. « previous next »
Pages: [1] Go Down Send this topic Print
Author Topic: Native Dynamic SQL and DBMS_SQL  (Read 713 times)
vivekmcm
Scout
****

Appreciate? +0/-0
Offline Offline

Posts: 119

Welcome!
« on: December 27, 2009 »
 Hi
can any body expalin me the difference between
Native Dynamic SQL and DBMS_SQL
Report to moderator   Logged
sibanjan
Trainer
****

Appreciate? +6/-0
Offline Offline

Posts: 51


Welcome!
« Reply #1 on: March 31, 2010 »
Native dynamic sql works faster than dbms_sql and so it improves performance.

NATIVE DYNAMIC SQL  uses EXECUTE IMMEDIATE statement to perform the operations and that is tightly integrated with pl/sql engine.Performance is some what  similar to that of static sql.

While DBMS_SQL  is strictly procedural and the coding style follows a strict sequence of steps.
« Last Edit: March 31, 2010 by sippsin » Report to moderator   Logged
Pages: [1] Go Up Send this topic Print 
« previous next »
 
Share this topic...
In a forum
(BBCode)
In a site/blog
(HTML)



Login with username, password and session length

Powered by MySQL Powered by PHP Powered by SMF 2.0 RC1.2 | SMF © 2006–2009, Simple Machines LLC Valid XHTML 1.0! Valid CSS!
Page created in 0.365 seconds with 20 queries.