When we give SELECT * FROM EMP; How does oracle respond?
Answer Posted / suresh
it will check for emp table(available or not).
1.if emp table available then it will retreive all the
colums from emp table..
2.if it is not available then it will give error..
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
what are the nonstandard string types? : Sql dba
What is the usage of sql functions?
How exception is different from error?
What are different types of functions in sql?
what are all types of user defined functions? : Sql dba
What is the use of procedures?
What is sql*loader and what is it used for?
What is parameter substitution in sql?
Why are sql stored procedures used?
What are sql functions? Describe in brief different types of sql functions?
What is the plv (pl/vision) package offers?
Will truncate release space?
What are the different parts of a package?
Is sql a backend language?
What are the methods of filing?