Select count(*) from emp where 1 = 2

sql query to get zero records from a table

Question Posted / nathan

Answer Posted / nathan

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is materialized view in Oracle?

1042

Is a rollback possible to any savepoint?

998

State and explain the different types of data models?

894

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1826

How to do a full database export?

1044

How to pass parameters to procedures?

973

How to load data from external tables to regular tables?

986

Difference between hot backup vs. Cold backup?

945

What is the quickest way to export a table to a flat file?

918

What are the system predefined user roles?

982

How to pass a parameter to a cursor in oracle?

1103

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

935

How to update a table row with a record?

961

What happens if you lost a data file?

978

What is oracle instant client?

970