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
which types of join is used in sql widely? : Sql dba
What is basic structure of pl sql?
Is clustered index a primary key?
Does truncate release storage space?
What are the types of views in sql?
How do you explain an index number?
What are different joins used in sql?
What is identity column in sql server?
what is datawarehouse? : Sql dba
what are all the common sql function? : Sql dba
How to get unique records from a table?
What is difference between cursor and trigger?
what is the functionality of the function htmlentities? : Sql dba
describe mysql connection using mysql binary. : Sql dba
why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba