sql query to get zero records from a table

Answer Posted / nathan

Select count(*) from emp where 1 = 2

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to write text literals in oracle?

611


How to check database size in Oracle?

640


What is an oracle wallet?

515


What are set operators?

646


How to use subqueries with the exists operator in oracle?

607






What is recycle bin in Oracle?

720


How do I call oracle stored procedures that take no parameters?

564


How to define and use table alias names in oracle?

508


What is oracle analytical function?

526


What is sequence?

624


How will you differentiate between varchar & varchar2?

591


Whether any commands are used for months calculation? If so, what are they?

597


What is a trigger oracle?

563


ABOUT IDENTITY?

1558


Explain the blob datatype?

620