Interested to Buy Any Domain ? << Click Here >> for more details...
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 is the difference between rollback and rollback to statements?
What is difference between inner join and self join?
How many joins in sql?
What is varchar example?
Can you selectively load only those records that you need? : aql loader
How to combine two stored procedures in sql?
What is the difference between sql, mysql and sql server?
What is delete command in sql?
Why do we use cursors?
Define commit?
How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?
How to Declare Fixed Length String Value In PL SQL
what is a trigger? : Sql dba
What is the use of count (*) in sql?
How do I run sql profiler?
