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 oracle database ? : Sql dba
How to run pl sql program in mysql?
How many joins can you have in sql?
Can you skip header records while loading? : aql loader
What is the use of sqldataadapter?
- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?
Is it possible to pass parameters to triggers?
Does truncate release storage space?
Explain what is sql*plus?
What are properties of the transaction?
how to calculate the difference between two dates? : Sql dba
How to rename a column in the output of sql query?
What are different methods to trace the pl/sql code?
Do we need commit after truncate?
What is number function in sql?
