recognise special characters ie $ sign

[Scunningham99]

Hi
How do I get script to recognise $ sign as a character in script. for example

select * from v$session;

I wish the dollar sign to be recognised. In solaris this would be done via v\$session. This does not seem to work ...
please advise



Sy UK

 

[KenCunningham]

Sy, have you tried enclosing in quotes?

I don't mind people who aren't what they seem. I just wish they'd make their mind up.

 

[stevexff]

By 'script' what do you mean? bash, ksh, perl?

Steve

[small]"Every program can be reduced by one instruction, and every program has at least one bug. Therefore, any program can be reduced to one instruction which doesn't work." (Object:erlDesignPatterns)[/small]

 

[Scunningham99]

ksh

Sy UK

 

[stevexff]

Been a while since I did any shell scripting, but try doubling the dollar sign

v$$session;

Steve

[small]"Every program can be reduced by one instruction, and every program has at least one bug. Therefore, any program can be reduced to one instruction which doesn't work." (Object:erlDesignPatterns)[/small]

 

[Ogzilal]

Hi,

try this as root or connect as oracle and remove 1st and last lines :

su - oracle <<-!EORA
export TABLE='v\$session'
export CMD=$(basename $0 .ksh)
export ORACLE_SID=YOUR_INSTANCE
sqlplus system/your_manager <<-!EOSQL
spool /tmp/${CMD}_$$.sql.lst
select * from \$TABLE;
spool off
exit
!EOSQL
!EORA

Ali