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
Is truncate ddl or dml?
Differentiate pl/sql and sql?
How will you distinguish a global variable with a local variable in pl/sql?
What are functions in sql?
What is rowid in sql?
What is a constraint? Tell me about its various levels.
How do I start sql profiler?
What is a data manipulation language?
What is an index in sql with example?
Can %notfound return null after a fetch?
How many triggers can be applied to a table?
What are all the different normalization?
What is dbo in sql?
Inline the values in PL/SQL, what does it mean.?
what is union, minus and interact commands? : Sql dba