When we give SELECT * FROM EMP; How does oracle respond?
- 24 Answers
- 52195 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 action do you have to perform before retrieving data from the next result set of a stored procedure ?
What are types of joins?
what is 'mysqladmin' in mysql? : Sql dba
Does view contain data?
what is the command line end user interface - mysql? : Sql dba
Is nosql relational?
What is sqlcommand?
What is the difference between sum and count in sql?
How to place comments in pl/sql?
List the various privileges that a user can grant to another user?
What is database migration?
What is a clob in sql?
Are null values same as that of zero or a blank space?
What is a null value?
What is function and procedure in pl sql?
