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
How many types of index are there?
Is oracel sql developer written in java?
Is a table valued function object?
How delete all records from table in sql?
Explain how exception handling is done in advance pl/sql?
How many joins can you have in sql?
How many primary keys can a table have?
Can we alter stored procedure?
How do I find duplicates in two columns?
What does joining a thread mean?
What is %type in sql?
What is data types in sql?
what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba
What are the features of pl sql?
How do you copy a table in sql?
