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

Answer Posted / sanjay

query will not give any results

Is This Answer Correct ?    0 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.

2890


can u send the sql dumps to sivakumarr1987@gmail.com plz help me

2600


What are the different windows events activated at runtime ?

2410


20. Using a set operator, display the client number of all clients who have never placed an order.

1803


How many types of database triggers exist?

579






What is set operator oracle?

532


What is proxy method?

545


What is open database communication (odbc) in oracle?

551


How to check the server version in oracle?

615


How can we view last record added to a table?

607


Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.

864


Can multiple columns be used in group by in oracle?

553


What are the uses of a database trigger?

521


What types of joins are used in writing subqueries?

569


What is coalesce function?

577