Select * from table where 1 = 2

sql query to get zero records from a table

Question Posted / kishor

Answer Posted / kishor

Is This Answer Correct ?

29 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How to drop a tablespace?

1039

How to define an oracle cursor variable?

1021

What is oracle rownum?

946

How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?

3193

What is a table in oracle?

972

What is the scope of a local variable?

1058

Is it possible to insert comments into sql statements return in the data model editor ?

2547

How to sort the query output in oracle?

1023

Why we use bulk collect in oracle?

1032

If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?

2288

What is ADDM Advisor in Oracle?

1167

What is program global area (pga) in oracle?

1022

What are dml statements in oracle?

1089

Explain the use of grant option in exp command.

1055

what is the scripts in data base?

2146