Interested to Buy Any Domain ? << Click Here >> for more details...
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 inbuilt functions in sql?
Explain the order of sql statement execution?
What is an index in sql with example?
How do temporal tables work?
How many commands are in sql?
What if we write return in procedure?
What is over () in sql?
How do I view stored procedures?
What is difference between stored function and application function?
What do you understand by pl/sql cursors?
What kind of join is join?
What is a record in a database?
Can I create table without primary key?
What is a schema sql?
What is the cause of mutating table error and how can we solve it?
