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 are triggers in sql?

583


What is mdb stand for?

556


What is an index in sql with example?

519


Explain dml and ddl?

552


What are the different operators available in sql?

577






What is difference between stored procedure and trigger?

537


How many types of tables are there?

509


what are the different type of normalization? : Sql dba

556


What is the difference between truncate and drop statements?

581


What is consistency?

715


How many sql are there?

518


how to decrement dates by 1 in mysql? : Sql dba

584


Define select, insert, create, delete, update, drop keywords

600


Why do we use procedures in pl sql?

522


How many columns should be in an index?

523