sql query to get zero records from a table

Answer Posted / neha_gupta

select null from emp

Is This Answer Correct ?    1 Yes 10 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to convert csv to table in oracle?

729


What is materialized view in Oracle?

839


What types of joins are used in writing subqueries?

745


Explain implicit cursor.

778


How to insert a record into a table?

835


What are joins, explain all types of joins?

1933


What are the limitations oracle database 10g xe?

765


In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?

2127


what is port in oracle? how is it related to database application.

1690


How to use group functions in the select clause using oracle?

818


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.

3097


What is the maximum number of triggers that can be applied to a single table?

779


In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.

1667


How to create a new view in oracle?

837


I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

1891