SQL Language (MOSC)

MOSC Banner

How to select column with # in name in shell script?

edited Feb 18, 2010 4:36AM in SQL Language (MOSC) 11 comments
 Anyone know how to select a column with a # in the name in a shell script ?
Example:

sqlplus<<EOF
/ as sysdba
select obj# from scheduler\$_window
;
EOF

I've tried \#, I've tried quotes--both " and '.  I've tried multiple \s.  How do I get the shell to treat the # like any other character instead of the start of a comment?

Any thoughts?
Richard

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center