Answer / kishor

Select * from table where 1 = 2

Answer / biswajit ghosh

SELECT * from TABLE
WHERE 1 = 2;

Answer / vawani sankar naik

SELECT * FROM TABLE WHERE 1=2;

Answer / nathan

Select count(*) from emp where 1 = 2

Answer / nanne

Your Question is not clear..i believe that your expecting retrieve the tables which are having zero rows in the database.

Yes...we can retrieve the zero rows tables from DB

Select * from dba_tables
where num_rows = 0;

Regards,
Nanne

Answer / vipul.solanki

select * from menu_master where rownum <1;

Answer / neha_gupta

select null from emp

What is the function of Redo Log ?

1 Answers  

How to recover a dropped index?

1 Answers  

what is difference between cartesian join & cross join even they give same result?

4 Answers   Bank Of America,

What are the oracle differences between nvl and coalesce

0 Answers  

Hi all, Can any one give answer for this question. Suppose im having employee table with fields, eno, ename, dept, address1, address2, address3. In address field employee can fill only address1 or address2 or address3... at a time he can fill three address fields. now i want all employee names who filled only one address field.. Plz its urjent can any one give querry.. Thanks in advance.

4 Answers   JPMorgan Chase,

How to create a new oracle data file?

0 Answers  

How can I combine multiple rows into a comma-delimited list in oracle?

0 Answers  

I have my backup RMAN script called backup_rman.sh. I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the O/S such that it would run as a background process?

1 Answers  

What is Data Block ?

2 Answers  

What is oracle database 10g express edition?

0 Answers  

Why should I use oracle database?

0 Answers  

What is a user account in oracle?

0 Answers