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 do you mean by stored procedures? How do we use it?
What is program debugging?
what is blob? : Sql dba
what is an index? : Sql dba
I need a function for a train ticket reservation please answer it thanks in advance
Explain constraints in sql?
What is denormalization in a database?
Explain what is table in a database?
what is bcp? When is it used?
What is sql and also describe types of sql statements?
What is scalar function in sql?
What do you mean by table in sql?
How do I create a sql script?
What is flag in sql?
How can the performance of a trigger be improved?