When we give SELECT * FROM EMP; How does oracle respond?
- 24 Answers
- 53641 Views
- Accenture, HCL, Infosys, I also Faced
- E-Mail Answers
Answer Posted / belal ansari
The sql engine select the records from the table EMS and it store in IMPLICIT CURSOR then display these recordes.
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What are the advantages of indexing?
What are the advantages of sql?
how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba
Which is faster truncate or drop?
What are the two types of exceptions.
Write a sql select query that only returns each name only once from a table?
What is the difference between database trigger and stored procedure?
What is an implicit commit?
Why coalesce is used in sql?
What is ttitle and btitle?
How to know the last executed procedure?
What are the different types of a subquery?
What are the key differences between SQL and PL SQL?
Why is sql*loader direct path so fast?
Why do we use set serveroutput on?
