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
Why do we use cursors?
What is sql in java?
Differentiate between syntax and runtime errors.
What are inner outer left and right joins in sql?
What is the difference between in and between in sql?
Does sql require a server?
What is sql clause?
What are the types of optimization?
What is the left table in sql?
What is sql engine in oracle?
Can a primary key be a foreign key?
What are the uses of merge?
explain the advantages and disadvantages of stored procedure? : Sql dba
Does db2 use sql?
What is the difference between union and union all command?
