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

what is the scenario where you take the database to NoArchivelog mode?

2332

How to rebuild an index in oracle?

1028

What are the different windows events activated at runtime ?

2900

How to check the oracle tns settings?

1047

interview questions with answer for cts

2587

How index is implemented in oracle database?

1006

Explain what are the different type of segments?

969

Can you create a synonym without having a table?

1045

what is difference between sql plus and sql*plus? (not sql and sql plus).

3904

Is primary key indexed by default in oracle?

987

How to work with data objects interactively?

989

What are the various constraints used in oracle?

1047

What is system global area (sga) in oracle?

994

What is a subquery in oracle?

1111

What is the quickest way to fetch the data from a table?

1058