When we give SELECT * FROM EMP; How does oracle respond?
- 24 Answers
- 50285 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 is the difference between the conventional and direct path loads? : aql loader
What is triggering circuit?
What is the cause of mutating table error and how can we solve it?
What view means?
Why do we use function in pl sql?
What does inner join mean?
Can a trigger call a stored procedure?
What is oracle and pl sql?
what is an alias command? : Sql dba
Can we use views in stored procedure?
Define implicit and explicit cursors.
Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?
What's the difference between a primary key and a clustered index?
What is pl sql package?
What does subquery mean in sql?
