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 rebuild an index in oracle?

1009

What is a private synonym?

1561

What is the difference between primary key and unique key and foreign key in oracle?

957

How to open and close an explicit cursor in oracle?

1031

If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...

2212

How do you get nicely formatted results from an oracle procedure that returns a reference cursor?

1055

What is a snapshot in oracle database?

1004

What is a user role in oracle?

1102

How to Truncate Table in Oracle

1135

How to use an explicit cursor without open statements?

1041

What is archive log in Oracle?

1117

What are the different editions of oracle?

1090

Explain what does a control file contain?

1083

What is a nested table?

1037

What is an oracle function?

1133