It will retrieve all the columns from emp table.

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

Question Posted / nagender k

Answer Posted / nagender k

Is This Answer Correct ?

21 Yes

6 No

Please Help Members By Posting Answers For Below Questions

how to create a test table in your mysql server? : Sql dba

1008

Is ms sql traffic encrypted?

924

How does postgresql compare to "nosql"?

1031

Can you have more than one trigger on a table?

1003

What is rollback?

1115

What are the advantages of normalization?

1078

What is primary key and unique key?

1121

Is left join inner or outer by default?

1019

How many types of indexes are there in sql?

985

how do you know if your mysql server is alive? : Sql dba

1078

What is a left inner join?

1015

Which command is used to delete a trigger?

1332

What are the benefits of pl sql?

1121

What are literals in sql server?

1170

what happens if you no create privilege in a database? : Sql dba

1001