Answer Posted / naresh
Basically Dynamic SQL means, you'll construct a SQL
statement dynamically while runtime and run it.
Why this needed: Since the stored database objects
(Procedures and Functions and others) will be compiled while
creating and stored inside a database.so everything has been
checked already. so whenever you make a call to these
programs they will directly run withou compiling second time.
since it runs without compiling you cannot use DDL commands
inside a stored program.
So to avoid this you can directly mention Execute Immediate
keywords in front of a SQL query dynamically in your
block.so that it'll work this time.
Hope this helps.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What are aggregate functions in sql?
How do you select unique values in sql?
what is msql? : Sql dba
Mention what does plv msg allows you to do?
Can we rename a column in the output of sql query?
What is the difference between in and between in sql?
Does sql support programming?
What is function and procedure in pl sql?
What is a file delimiter?
What is sap sql anywhere?
What is difference sql and mysql?
What is pl sql architecture?
what are the types of join and explain each? : Sql dba
Explain ddl statements in pl/sql?
Does access use sql?
