When we give SELECT * FROM EMP; How does oracle respond?
- 24 Answers
- 52193 Views
- Accenture, HCL, Infosys, I also Faced
- E-Mail Answers
Answer Posted / radha sri seshu.kolla
when we fire select * from emp; first oracle engine checks
the data dictionary called user_tables. if the table emp
existed then it checks all permissions then contacts the
data dictionary called user_tab_columns, and according to
the given condition the sql statement will be executed
| Is This Answer Correct ? | 9 Yes | 2 No |
Post New Answer View All Answers
explain the delete statements in sql
What is #table in sql?
What is the difference between partitioning and sharding?
How to start oracle sql developer?
How do I view a table in sql?
How many types of index are there?
How do I view stored procedures?
What are the different datatypes available in PL/SQL?
How do I write a cron which will run a sql query and mail the results to agroup?
What is the difference between the conventional and direct path loads? : aql loader
What is the syntax to add a record to a table?
what is auto increment? : Sql dba
What is the starting oracle error number?
how many columns can be used for creating index? : Sql dba
What is a rank in sql?
