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 is the difference between char_length and length? : Sql dba

576

How to raise user-defined exception with custom sqlerrm ?

682

How to return an array from java to pl/sql?

597

How to know the last executed procedure?

595

What are the benefits of pl sql?

538

Explain some predefined exceptions.

594

what are set operators in sql? : Sql dba

546

What is difference between left and right outer join?

530

What is normalisation and its types?

556

What is sql dialect?

536

What is the primary key?

549

Why self join is used in sql?

508

What is vector point function?

575

What is function and procedure in pl sql?

523

Explain the uses of a database trigger?

579