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

Answer Posted / nagender k

It will retrieve all the columns from emp table.

Is This Answer Correct ?    21 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is percent sign in sql?

713


Mention what does the hierarchical profiler does?

557


What is memory optimized?

551


How many types of normalization are there?

487


what is the use of friend function? : Sql dba

541






What's the difference between a primary key and a clustered index?

510


What is bitemporal narrowing?

722


What programs use sql?

523


How to sort the rows in sql.

600


What is use of term?

618


What is difference between sql and excel?

513


How to find 3rd highest salary of an employee from the employee table in sql?

565


Differentiate between % rowtype and type record.

731


how to install mysql? : Sql dba

580


Why should I use postgresql?

561