Interested to Buy Any Domain ? << Click Here >> for more details...
When we give SELECT * FROM EMP; How does oracle respond?
- 24 Answers
- 56979 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 use of partition by in sql?
Where not exists in sql?
What is the difference between inner join and natural join?
What is embedded sql in db2?
explain the difference between delete , truncate and drop commands? : Sql dba
what is 'mysqlshow'? : Sql dba
What are the operators used in select statements?
How many primary keys can a table have?
What are few of the schema objects that are created using PL/SQL?
what are the different index configurations a table can have? : Sql dba
How do you declare a constant?
How run sql*plus commands that are stored in a local file?
Explain the uses of control file.
What is pl sql and why it is used for?
Is primary key is clustered index?
