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 many sql commands are there?

1158

Explain two easy sql optimizations.

1075

Is sql the best database?

1027

What are the differences between implicit and explicit cursors?

1110

What happens when a trigger is associated to a view?

971

How does stored procedure reduce network traffic?

1065

Why is pl sql needed?

1004

Explain the methods used to protect source code of pl/sql.

1074

What is embedded sql with example?

1099

Why do we create views in sql?

1218

What are triggers in sql?

1061

How to look at the current sql*plus system settings?

1215

How do I create a memory optimized filegroup?

1012

What are tables and fields in the database?

1188

What are actual parameters and formal parameters?

1176