Interested to Buy Any Domain ? << Click Here >> for more details...
When we give SELECT * FROM EMP; How does oracle respond?
- 24 Answers
- 56924 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
Is id a reserved word in sql?
What is the importance of sqlcode and sqlerrm?
How to return multiple rows from the stored procedure?
What are the different sql languages?
Which query operators in sql is used for pattern matching?
what is rdbms? : Sql dba
name 3 ways to get an accurate count of the number of records in a table? : Sql dba
Explain the difference between drop and truncate commands in sql?
What are the uses of merge?
How are sql commands classified?
How do I debug a stored procedure?
What is user defined functions?
What are the uses of sysdate and user keywords?
What is difference between rank () row_number () and dense_rank () in sql?
Can we insert data into view?
