Select count(*) from emp where 1 = 2

sql query to get zero records from a table

Question Posted / nathan

Answer Posted / nathan

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

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

1017

What to do if dba lost the system password?

1146

What is an oracle cursor variable?

1046

What are the general rules on data consistency?

988

Use of an integrity constraint is better to validate data. Explain

1020

Explain the use of full option in exp command.

1089

What is the max number of columns in an oracle table?

971

Please explain oracle left join with an example?

1016

Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??

1715

What is merge in oracle?

1033

HI, Please let me know the syllabus for Oracle OCA and OCP Certification

2480

Explain coalesce function?

1171

What do you understand by a database object? Can you list a few of them?

999

What are the uses of Database Trigger ?

1682

Select all the employees who were hired in last 2 years and who works in dept where max managers are working.

2942