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

Answer Posted / vijay sonawane

show all records of table as output

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to connect to a local oracle 10g xe server?

724


How to define an anonymous block?

828


How to get maxsal , minsal, ename department wise in single query

1306


In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?

2013


you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz

1741


Explain the use of file option in exp command.

872


Is the After report trigger fired if the report execution fails ?

2699


What is an anonymous block?

899


What are a query and state the different types of queries and their uses?

740


How to create an initialization parameter file?

742


What are the types of trigger in oracle?

760


Which is better Oracle or MS SQL? Why?

5858


What privilege is needed for a user to create views in oracle?

799


Explain index?

999


Can we create database in oracle using command line ?

810