When we give SELECT * FROM EMP; How does oracle respond?

Question Posted / pankit1515

24 Answers
50507 Views
Accenture, HCL, Infosys, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

When we give SELECT * FROM EMP; How does oracle respond?..

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

When we give SELECT * FROM EMP; How does oracle respond?..

Answer / sun

Oracle responds as

It retrieves all records from the EMP table.

Is This Answer Correct ?

1 Yes

2 No

When we give SELECT * FROM EMP; How does oracle respond?..

Answer / reddy

IT WILL GIVES THE ALL THE ATTRIBUTS IN EMP TABLE

Is This Answer Correct ?

5 Yes

8 No

When we give SELECT * FROM EMP; How does oracle respond?..

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

Post New Answer