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
Can you skip header records while loading? : aql loader
how does a local variable is defined using t-sql? : Transact sql
Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?
how to check server status with 'mysqladmin'? : Sql dba
How many parts of a pl sql block are optional?
What is the difference between having clause and where clause?
how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba
what is a foreign key ? : Sql dba
How many types of sql are there?
how to create a new table by selecting rows from another table in mysql? : Sql dba
Explain the select statement in sql?
Can a select statement fire a trigger?
Which is better join or subquery?
How to write pl sql program in mysql command prompt?
What is a call statement? Explain with an example.
