Answer Posted / vishal kumar
Sql statement should be written in quotes like
'select table1.col1, tabel2.col2 from table1,table2 where
table1.col3=table2.col4'
and we can execute through below command "execute immidiate"
EXECUTE IMMEDIATE 'select table1.col1, tabel2.col2 from
table1,table2 where table1.col3=table2.col4'
it execute at runtime, means its not allowed as static.
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What are the different datatypes available in PL/SQL?
What is the use of sql trace?
What are records give examples?
What is information schema in sql?
What are tables and fields?
How to use sql*plus built-in timers?
Can we use ddl statements in stored procedure sql server?
explain normalization concept? : Sql dba
What is pls_integer in pl sql?
What is a join query?
Explain character-manipulation functions?
How do you know if a relationship is 2nf?
What is cursor in pl sql?
What is union and union all keyword in sql and what are their differences?
Where is pl sql used?
