SELECT * FROM TABLE WHERE 1=2;

sql query to get zero records from a table

Question Posted / vawani sankar naik

Answer Posted / vawani sankar naik

Is This Answer Correct ?

7 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is oracle and what are its different editions?

1118

How to set a transaction to be read only in oracle?

1137

What is the usage of merge statement?

1202

Explain constraining triggers.

1161

How remove data files before opening a database?

1133

Name the three major set of files on disk that compose a database in Oracle?

1170

why should i declare foreign key constraint as self relation instead of binary relation in tables ?

2089

How to write text literals in oracle?

1118

Does oracle charge for java?

1115

Explain the use of consistent option in exp command.

1139

What is an oracle cursor variable?

1131

How to update a table row with a record?

1065

What is recovery manager(rman) backup in Oracle?

1230

what is dynamic SGA and static SGA

4485

how to join query for one source type is oracle another source type is sql server ?

2479