using $ dollar symbal as text

UNIX for Beginners Q & A UNIX for Dummies Questions & Answers
1

All,

How can I get unix to handle the symbol $ as text rather than thinking its a variable value.

e.g When calling a sql script from unix:

exec SQL_PACKAGE('OPS$JOHN.EMP')

where OPS$JOHN is the owner of the table ($JOHN is not a variable!)

Thanks

2

You might have to experiment but either " ", or ' ' around the whole variable may do it, or, try a \ before the $.