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
Enlist some predefined exceptions?
What are the qualities of 2nf?
Explain the the delete statements in sql?
how to escape special characters in sql statements? : Sql dba
What are two statement types in sql?
Can I call a procedure inside a function?
How many sql statements are used?
What view means?
What are character functions in sql?
What is an exception in PL/SQL? What are the two types of exceptions?
how mysql optimizes distinct? : Sql dba
how many sql ddl commands are supported by 'mysql'? : Sql dba
What are local and global Indexes and where they are useful.
What type of database is sql?
how to create a table index in mysql? : Sql dba
