Oracle search for this table in the database and returns all the rows.

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

Question Posted / vinay dixit

Answer Posted / vinay dixit

Oracle search for this table in the database and returns
all the rows.

Is This Answer Correct ?

6 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What are the two parts of design view?

973

What is the difference between cluster and non-cluster index?

1047

What are different sql data types?

954

What is normalization in sql?

962

Why do we use triggers?

914

What is the difference between left outer join and left join?

943

Can sql function call stored procedure?

956

What is procedure explain with program?

949

How do I know if I have sql express or standard?

976

Explain alias in sql?

994

Explain ddl statements in pl/sql?

958

Which version of sql do I have?

995

How to create a menu in sqlplus or pl/sql?

1063

What is the difference between subquery and correlated query?

989

How is sql used in oracle?

969