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 the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?

1160

What happens in oracle commit?

1073

Explain an exception?

1053

Can we store images in oracle database?

1063

How translate command is different from replace?

1137

How to store only time; not date and time?

1065

What is the difference between sharding and replication?

1128

What is a nested table?

1108

How to name query output columns in oracle?

1237

How do we represent comments in oracle?

1093

Please explain oracle data types with examples?

1128

How to connect to oracle using service name instead of sid?

1067

How many file formats are supported to export data?

1260

How to count duplicated values in a column in oracle?

1100

What operating systems are supported by oracle database 10g xe?

1083