Here ya go:


select 'upd schedule ' || schedule_name || ' type=admin priority=5' as
"xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx" from
admin_schedules



The "xxxxx.." are there only to force the column wider so the schedule names
won't wrap to the next line.
If you still can't keep it from wrapping, you can always do:

select '@@@ " || schedule_name || ' ###'
then pipe (or cut & paste) the output into a file and do a change all on the
@@@ and ###, etc.

************************************************************************
Wanda Prather
The Johns Hopkins Applied Physics Lab
443-778-8769
wanda_prather AT jhuapl DOT edu

"Intelligence has much less practical application than you'd think" -
Scott Adams/Dilbert
************************************************************************





-----Original Message-----
From: Jim Healy [mailto:James.Healy AT AXA-TECH DOT COM]
Sent: Wednesday, September 11, 2002 11:29 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: help with script


Can anyone help me wih the following script.
I'm trying to go out and updat al  the admin scripts I have and can't seem
to get this one right


SELECT 'upd schedule ' || SCHEDULE_NAME FROM ADMIN_SCHEDULES and ||
'type=admin priorty=5'


**********************************************************************

Confidentiality Note:  This e-mail is intended only for the
person or entity to which it is addressed and may contain
information that is privileged, confidential or otherwise
protected from disclosure.  Dissemination, distribution
or copying of this e-mail or the information herein by
anyone other than the intended recipient, or an employee
or agent responsible for delivering the message to the
intended recipient, is prohibited.  If you have received
this e-mail in error, please contact the sender and destroy
the original message and all copies.

**********************************************************************