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 ways on commenting in a pl/sql code?
What is procedure explain with example?
Which is better stored procedure or query?
How many tables can you join in sql?
What is difference between joins and union?
Explain sql data types?
What is the maximum size of sqlite database?
How can you fetch common records from two tables?
What port does sql server use?
what is table? : Sql dba
Can we create index on primary key?
What has stored procedures in sql and how we can use it?
What kind of join is join?
how to dump a table to a file with 'mysqldump'? : Sql dba
What is faster join or subquery?
