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
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
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
Use the translate command tr. Type man tr for help with using it.
RWB
Guang Mei [EMAIL PROTECTED]@fatcity.com on 02/03/2003 12:39:48 PM
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Hi:
I have a
Hi:
I have a quick question about replacing $ with \$ on unix. I need to
convert string 123$45$678 to 123\$45\$678 through a pipe. I tried with
sed command, but could not get it to work:
essex$ echo 123$45$678 | sed s/$/\$/g
123578$
essex$ echo 123$45$678 | sed s/$/\\$/g
123578$
Maybe there
Please note the use of single-quotes (') instead of
double-quotes () in the echo command, as well as the use of
single-quotes in the sed command...
$ echo '123$45$678' | sed 's/\$/\\$/g'
123\$45\$678
Hope this helps...
Hi:
I have a quick question about replacing $ with \$ on
unix.
:
Subject: OT: unix script quetion: to
replace
echo '123$45$678' | sed -e 's#\$#\\$#g'
Guang Mei [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
02/03/2003 10:39 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:OT: unix script quetion: to replace
script
quetion: to replace $ with \$
[EMAIL PROTECTED]
02/03/03 11:39 AM
Please respond to
ORACLE-L
Hi:
I have a quick question about replacing $ with \$ on unix. I need to
convert string 123$45$678
: OT: unix script quetion: to
replace $ with \$
[EMAIL PROTECTED
recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: OT: unix script quetion: to replace $ with \$
Hi, Brian:
Thanks for your (and others) help. I can not use signle quotes in echo
in my program. The reason is this:
I am trying to run table analyze in multiple treads (I
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;
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: OT: unix script quetion: to replace $ with \$
Hi, Brian:
Thanks for your (and others) help. I can not use signle quotes in echo
in my program. The reason
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
14 matches
Mail list logo