Interested to Buy Any Domain ? << Click Here >> for more details...
When we give SELECT * FROM EMP; How does oracle respond?
- 24 Answers
- 57911 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
Why do we need sharding?
how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba
What are triggers and its types?
What is an exception in pl/sql?
What is crud diagram?
How many clustered indexes can be created on a table?
Difference between truncate, delete and drop commands?
What is not in sql?
How to run pl/sql statements in sql*plus?
What is the difference between row level and statement level trigger?
What type of database is sql?
Can we insert delete data in view?
What are the disadvantages of file system?
What is the difference between left outer join and left join?
What is clustered index in sql?
