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
- 7469 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 is the difference between left join and right join?
What is a dynamic query?
Explain mutating table error.
What are all the different types of indexes?
What is equi join in sql?
What is java sql driver?
What sql does db2 use?
Is pl sql a programming language?
What is pl/sql language case sensitive?
How many primary keys can a table have?
How to place comments in pl/sql?
Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?
What is the difference between microsoft access and sql?
how can we destroy the cookie? : Sql dba
How can we find duplicate records in a table?
