Oracle responds as It retrieves all records from the EMP table.

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

Question Posted / sun

Answer Posted / sun

Oracle responds as

It retrieves all records from the EMP table.

Is This Answer Correct ?

1 Yes

2 No

Please Help Members By Posting Answers For Below Questions

how many groups of data types? : Sql dba

569

What does where 1/2 mean in sql?

540

Why is pl sql used?

531

how to shut down the server with 'mysqladmin'? : Sql dba

549

What are the types of subqueries?

574

How do we use distinct statement? What is its use?

558

what is dbms? : Sql dba

546

What is db journal file?

523

How do I count rows in sql query?

493

What is a dirty read sql?

488

Show how functions and procedures are called in a pl/sql block.

588

explain advantages of innodb over myisam. : Sql dba

648

what are the join types in tsql? : Transact sql

579

What is left inner join in sql?

520

What are expressions?

568