The problem is that if LINE contains "$" (dollar sign), as some InterMedia table names do, the piped command will fail.
Guang > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of > Stephen Lee > Sent: Monday, February 03, 2003 3:54 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: OT: unix script quetion: to replace $ with \$ > > > > Would something like this be adaptable to your stuff? > > #!/usr/bin/ksh > > { > sqlplus -s <<-XXX > joe/blow@SID > set this and that off > set the other thing and trimspool on > set whatever else > select table_name from dba_tables where owner = 'BUBBA'; > } | while read LINE; do > echo "exec analyze_that_puppy BUBBA.$LINE real good;" | sed > 's/\$/\\\$/g' > done > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Stephen Lee > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: gmei INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).