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
How many types of keys are there in sql?
Which is better stored procedure or query?
What is the use of %rowtype?
What is a data definition language?
Which software is used for pl sql programming?
What is case function?
Which join is like inner join?
Which one is better subquery or joins?
Which certification is best for sql?
What is scalar function?
Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?
What is a primary key sql?
how can we repair a mysql table? : Sql dba
What is localdb mssqllocaldb?
What are the benefits of triggers?