Re: select from dual?

Did you mean somethink like this: select 30,'where name in (''NAME1'',''NAME2'')' || ' ;' from dual; Tatireddy, Shrinivas (MED, Keane) pe: Hi lists Whats wrong with the following statement:- select 30,'where name in ('NAME1','NAME2')' || ' ;' from dual; where as the following is

RE: select from dual?

i think the following code should work - select 30,'where name in (''NAME1'',''NAME2'')' || ' ;' from dual; the character fields should be seperated by double quotes instead of single. santosh Hi lists Whats wrong with the following statement:- select 30,'where name in

select from dual?

Hi lists Whats wrong with the following statement:- select 30,'where name in ('NAME1','NAME2')' || ' ;' from dual; where as the following is working fine: select 30, 'where id in (10,20)' || ' ;' from dual; can anybody throw some light? thanx in adv srinivas -- Please see the official

Re: select * from dual;

or Life saver: http://www.ud.com Use spare CPU to assist in cancer research. -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 25 September 2001 19:23 Gurus, I get the following on select * from dual; when the database is in the unmounted and the mounted

select * from dual;

Gurus, I get the following on select * from dual; when the database is in the unmounted and the mounted state... ADDR INDXINST_ID D -- -- - 01653D38 01X and the normal D - X when it is open. What does