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 difference between oracle enterprise edition and oracle express edition?

2 Answers  

create or replace procedure show_tab_rec ( P_tab VARCHAR2 ) IS cmd varchar2(50); begin cmd := 'select * from '|| P_tab; for int in ( execute immediate cmd ) loop dbms_output.put_line ( int.ename||' '||int.deptno); end loop; end; when i m compling this procedure i m getting this error PLS-00103: Encountered the symbol "IMMEDIATE" when expecting one of the following: . ( ) , * @ % & | = - + < / > at in is mod remainder not range rem => .. <an exponent (**)> <> or != or ~= >= <= <> and or like LIKE2_ LIKE4_ LIKEC_ between || multiset member SUBMULTISET_ PLZ solve this error give this question answer asap Thanks advance.......

1 Answers   HCL,

how to find the n'th highest salary from emp ?

10 Answers  

Does oracle partitioning improve performance?

0 Answers  

What are the ways tablespaces can be managed and how do they differ?

0 Answers  

How to define a data field as not null?

0 Answers  

In my table i have 4 columns with 100 records but in that 4 columns one column contains all NULL values so can i add NOT NULL CONSTRAINT on that column......... ok if it is not possible, can i add NOT NULL CONSTRAINT from 101 Record Onwards?

4 Answers   Cap Gemini,

How to use "if" statements on multiple conditions?

0 Answers  

Is truncate autocommit in oracle?

0 Answers  

How you open and close a cursor variable.Why it is required?

2 Answers  

how do u know the total no of rows in a table?

6 Answers  

Differentiate the standard purchase order,Blanket purchase agreement,Contract purchase agreement,Planned purchase order?

1 Answers