When we give SELECT * FROM EMP; How does oracle respond?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / sun
Oracle responds as
It retrieves all records from the EMP table.
Is This Answer Correct ? | 1 Yes | 2 No |
Answer / veni
WE give this query when, we need to view the entire record
of emp table. ( i.e) it will display all the rows and
columns of emp table. and the oracle respond the same as
per the query given.
Is This Answer Correct ? | 2 Yes | 5 No |
What is pl/sql and what is it used for?
How bulk collect improves performance?
How to add Foreign key in a table after the creation of the table?
What is the difference between left and left outer join?
Hi Everyone, How to get fist and last record from a table in oracle? Thanks in advance
Why do we need a foreign key?
What is the difference between subquery and correlated query?
if table named a is there and 4 records are there then how to swap (1 and 3) and (2 and 4) records at a time
What is %type in sql?
Define union, minus, union all, intersect ?
can use the following like overloading concept in a single package: procedure p1(a varchar), procedure p1(a varchar2), procedure p1(a char)
Is delete faster than truncate?