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 are privileges and grants?

1002

What is the quickest way to fetch the data from a table?

1001

Is there an oracle sql query that aggregates multiple rows into one row?

934

What are the built-in functions used for sending Parameters to forms ?

3309

How do I start tns listener?

989

What is coalesce function?

1009

What is control file used for?

1102

What is integrity and what is constraint??Explain with example

2215

What is an oracle cursor variable?

1008

How to use "in out" parameter properly?

1000

What are internal user account in oracle?

949

What is an external table?

959

What is oracle used for?

971

Is java required for oracle client?

928

What is the string concatenation operator in oracle?

1093