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
Received on Wed Jun 02 2004 - 16:19:18 CDT
