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
- 7424 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 are the advantages of mysql in comparison to oracle? : Sql dba
What is trigger and how to use it in sql?
Explain the difference between rename and alias?
Explain lock escalation? : Transact sql
Enlist the characteristics of pl/sql?
How many primary keys can a table have?
How to raise user-defined exception with custom sqlerrm ?
explain advantages of myisam over innodb? : Sql dba
What is the advantage of nosql?
a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution
What is pl sql architecture?
differentiate between float and double. : Sql dba
What is meant by truncate in sql?
what is self join and what is the requirement of self join? : Sql dba
Does sql backup shrink transaction log?
