RE: SQLPLUS ?
- From: "Norris, Gregory T [ITS]" <gregory.t.norris@xxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 3 Jun 2004 08:06:57 -0500
Why? That's a varchar2 column... it doesn't contain trailing spaces.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Martha Delgado
Sent: Wednesday, June 02, 2004 4:38 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: SQLPLUS ?
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]En nombre de Seema Singh
Enviado el: Miércoles, 02 de Junio de 2004 06:22 p.m.
Para: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
