When we give SELECT * FROM EMP; How does oracle respond?
- 24 Answers
- 53570 Views
- Accenture, HCL, Infosys, I also Faced
- E-Mail Answers
Answer Posted / vaibhavi_dixit
When the above statment is fired, Oracle checks for
following things,
1.Syntax Correctness.
2.User Priviledges on Emp Table.
If the above two things are correct then, all columns and
all rows from Emp table are selected in an Implicit area
and then are send to User.
Cheers
VD
| Is This Answer Correct ? | 73 Yes | 3 No |
Post New Answer View All Answers
What are the types of variables use in pl sql?
What is join view in sql?
Why commit is not used in triggers?
what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba
What is faster join or subquery?
Can we use two order by clause in query?
what is meant by urlencode and urldocode? : Sql dba
Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?
Which version of sql do I have?
What is the difference between explicit and implicit cursors in oracle?
How does index help in query performance?
List and explain the different types of join clauses supported in ansi-standard sql?
Does inner join remove duplicates?
What are keys in sql?
What are different types of tables in sql?
