Prepare for your Next Interview
This is a discussion on an interesting topic within the SQL forums, part of the Databases category; when to use dynamic sql rather than static sql if answer is in static sql one hve a fixed sql statement but where in dynamic sql u can build sql ...
|
|||
|
an interesting topic
when to use dynamic sql rather than static sql
if answer is in static sql one hve a fixed sql statement but where in dynamic sql u can build sql statements as charecter string at run time den wat is the difference between ref cursor and dynamic sql ![]() |
| Sponsored Links |
|
|||
|
Re: an interesting topic
in normal PL/SQL block it will allow only DML statements to execute.if we are executing other than DML like DDL(CREATE ,ALTER ,DROP),DCL(GRANT,REVOKE) AND SESSION CONTROL LANGUAGE(CREATE SESSION) it will come out from the block and gives an error.
by using dynamic sql we can execute DDL ,DCL,SESSION CONTROL langueges.this is one advantage of dynamic sql. |
|
|||
|
Re: an interesting topic
Quote:
|
|
|||
|
Re: an interesting topic
Use dynamic sql when the anme of the objects are not known in advance and passed only at runtime.
|
| The Following User Says Thank You to debasisdas For This Useful Post: | ||
![]() |
|
| Thread Tools | |
| Display Modes | |
|
|
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| B.Tech Project Topic | sunnysharma85 | Career Advice | 1 | 12-26-2007 05:49 AM |
| Topic in Networking domain on J2EE | Geek_Guest | Career Advice | 0 | 07-25-2007 11:31 PM |
| new GD topic | vmshenoy | Suggestions & Feedback | 2 | 01-10-2007 03:34 AM |
| Newbie : there is no topic | Ralfman68 | Downloads | 2 | 12-03-2006 07:40 PM |
| Question on topic Collection & Thread | abdul.sayeed | Java | 0 | 11-30-2006 01:59 AM |