it will display all the records of emp table.

select * from emp
what happened internally when we write this query in the sql
prompt?

Question Posted / dinesh chandra

Answer Posted / dinesh chandra

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is flashback in Oracle?

589

master table and child table performances and comparisons in Oracle ?

1677

What is oracle datasource?

567

definition of cluster and non-clustered index?

2486

Whether any commands are used for months calculation? If so, what are they?

606

How to define a cusotmer as a supplier in ORACLE R12

1735

Can a formula column be obtained through a select statement ?

1853

What is raw datatype in oracle?

595

What is an oracle and why it is used?

635

What are the four Oracle system processes that must always be up and running for the database to be useable?

599

How to convert characters to numbers in oracle?

600

If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?

1809

Explain what are the type of synonyms?

591

What is the dynamic sql in oracle?

612

What is the difference between I and G in Oracle?

616