Interested to Buy Any Domain ? << Click Here >> for more details...
What is dynamic SQl and how you will create and execute
dynamic sql?
- 2 Answers
- 7315 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / ravi singh
Dynamic SQL enables you to executes your SQL statement at run time on the basis of different conditions. They can be executed with the help of creating SQLs at run time. you can store your where clause or sql statements in variables and on the basis of requirements you can execute them.
Dynamic SQL comprises reference cursors.
for ex: open cursor for select a,b,c from table_name;
execute immediate 'select a,b from table_name'
you can store the result set into variables too.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What does sql stand for?
How many tables can you join in sql?
How can you save or place your msg in a table?
How to revise and re-run the last sql command?
how to calculate the difference between two dates? : Sql dba
Explain two easy sql optimizations.
Differentiate between % rowtype and type record.
how to drop an existing table in mysql? : Sql dba
How much does sql certification cost?
what is 'trigger' in sql? : Sql dba
What is the syntax to add a record to a table?
how many sql dml commands are supported by 'mysql'? : Sql dba
Can we use having without group by in sql?
How do I create a sql database?
Explain the savepoint statement.
