sql query to get zero records from a table

Answer Posted / biswajit ghosh

SELECT * from TABLE
WHERE 1 = 2;

Is This Answer Correct ?    8 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to start a new transaction in oracle?

593


What is the usage of merge statement?

672


What is Trigger in Oracle?

575


How to synchronize 2 schema's objects?

1690


What is set verify off in oracle?

579






What is ASM (Automatic Storage Management) in Oracle?

714


How do I escape a reserved word in oracle?

630


What are oracle functions?

553


how can we store any pdf file in oracle

1644


I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance

1849


Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?

558


How to add a new column to an existing table with a default value?

548


How can you merge two tables in oracle?

569


What is Undo Management Advisor in Oracle?

613


what is IDE,DMV in sql server?

2248