SELECT * FROM TABLE WHERE 1=2;

sql query to get zero records from a table

Question Posted / vawani sankar naik

7 Answers
11716 Views
CTS, I also Faced
E-Mail Answers

Answer Posted / vawani sankar naik

SELECT * FROM TABLE WHERE 1=2;

Is This Answer Correct ?

7 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to get maxsal , minsal, ename department wise in single query

1552

hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.

2370

What is recovery manager in Oracle?

1059

Is there a function to split a string in plsql?

1068

What are the oracle built-in data types?

1081

How to drop a stored function?

1140

What is an external table?

1027

what happened to the global index when I truncate the data in one of the partition?

2027

What is the data pump import utility?

1040

How to convert a date to char in oracle? Give one example.

1073

How to define a data source name (dsn) in odbc manager?

1037

1) Does oracle have any table which contain all the exceptions and it's code internally?

1755

How to create a new user account in oracle?

1022

How to apply filtering criteria at group level in oracle?

1045

What is oracle rowcount?

1090