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 do you mean by stored procedures?
How do you remove duplicate records from a table?
Can we connect to postgresql using sql developer?
Is it possible to create startup or shutdown trigger for on-schema?
Can we use join in subquery?
What is sql clause?
How do rank () and dense_rank () differ?
What is PL/SQL Records?
How to get each name only once from an employee table?
Why do we need pl sql?
What is oracle pl sql developer?
how can we optimize or increase the speed of a mysql select query? : Sql dba
Does sql*plus also have a pl/sql engine?
what are the differences between char and varchar? : Sql dba
what is the syntax used for partition in tsql? : Transact sql