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 [EMAIL PROTECTED] "Intelligence has much less practical application than you'd think" - Scott Adams/Dilbert ************************************************************************ -----Original Message----- From: Jim Healy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 11, 2002 11:29 AM To: [EMAIL PROTECTED] 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. **********************************************************************