RE: SQLPLUS ?

From: Martha Delgado <mdelgado_at_devoto.com.uy>
Date: Wed, 2 Jun 2004 18:38:15 -0300
Message-ID: <002d01c448e9$ea0ac250$79c809c0@PCMARTHAD>

Hi,
If I were you, Y would use rtrim(table_name) and I would use the "set linesize n" where n is the length of the line. regards

-----Mensaje original-----

De: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]En nombre de Seema Singh Enviado el: Miércoles, 02 de Junio de 2004 06:22 p.m. Para: oracle-l_at_freelists.org
Asunto: SQLPLUS ?

I want to create script in single line
like
select 'create snapshot dev.'||table_name||' '|| 2 'using index tablespace INDX refresh fast with rowid start with sysdate next sysdate + 7 as (select * from dev.' 3 ||table_name||'@testone);' from dba_tables 4* where owner='DEV' and table_name like 'CON_%'

I'm getting this script after spooling above query.I want output of above query in single line.
What SQLPLUS parameters I need to setup? thx -seema

MSN Toolbar provides one-click access to Hotmail from any Web page – FREE download! http://toolbar.msn.click-url.com/go/onm00200413ave/direct/01/

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Please see the official ORACLE-L FAQ: http://www.orafaq.com

Received on Wed Jun 02 2004 - 16:38:30 CDT