OraFAQ Forum: Linux » v$ view access through shell script

Home » Infrastructure » Linux » v$ view access through shell script (10.2.0.1,rhel 4)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

v$ view access through shell script [message #299779]

Wed, 13 February 2008 03:11

varu123
Messages: 754
Registered: October 2007

Senior Member

how to access dictionay views in shell scripts?
For ex,
if i try to access v$datafile,it can only read v of v$datafile and hence the error table or view does not exist.
How to use $ sign for such views?

Report message to a moderator

Re: v$ view access through shell script [message #299785 is a reply to message #299779]

Wed, 13 February 2008 03:19

Michel Cadot
Messages: 68775
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Put a \ before $

Regards
Michel

Report message to a moderator

Re: v$ view access through shell script [message #299786 is a reply to message #299779]

Wed, 13 February 2008 03:19

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

oracle@mutation#sqlplus -s scott/tiger << EOF
> select name from v\$database;
> exit;
> EOF

NAME
---------
MUTATION

Report message to a moderator

Previous Topic:	Problem with Oracle 10g XE in Ubuntu Gutsy Gibbon
Next Topic:	Oracle 10g wants swap coould i ovveride it?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 12 04:30:56 CST 2026