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

Answer Posted / dinesh chandra

it will display all the records of emp table.

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a nvl function?

641


Explain about integrity constraint?

705


What is ASM (Automatic Storage Management) in Oracle?

793


hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.

2043


How to open and close an explicit cursor in oracle?

647






How are extents allocated to a segment?

665


Why do we need oracle client?

597


What is a snapshot in oracle database?

657


What is the maximum limit on the number of columns in a table?

627


What is a synonym? What are its various types?

709


What is a data dictionary and how can it be created?

693


How to execute the package in oracle?

670


What is tns name?

631


What is SQL Tuning Advisor in Oracle?

716


What are the differences between blob and clob in oracle?

665