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 enter a new row into a table interactively?

544

Explain the truncate in oracle?

543

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

575

Is there a combination of "like" and "in" in sql?

575

What is memory advisor in Oracle?

627

Compare and contrast between sql and sql server and explain its various functions?

527

What privilege is needed for a user to connect to oracle server?

555

Explain about the analyze command in oracle?

579

Explain the use of owner option in exp command.

566

How to count duplicated values in a column in oracle?

550

what is dynamic SGA and static SGA

3830

What is index-organized table in Oracle?

565

What happens if you lost a data file?

576

how to clone 9i Database on to 10g Database.

1820

Oracle

1843