When we give SELECT * FROM EMP; How does oracle respond?
- 24 Answers
- 53590 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
How can I speed up sql query?
what is an index? : Sql dba
What is fmtonly in sql?
What is the execution plan in sql?
What is memory optimized?
What is optimistic concurrency control? : Transact sql
Explain the uses of a database trigger?
Explain what is rdbms?
Can we create table in function?
What is data definition language?
How do I pipe the output of one isql to another?
what are the system privileges that are required by a schema owner (user) to create a trigger on a table?
How do you copy a table in sql?
How do I trace sql profiler?
How many clustered indexes can you have?
