Home » Infrastructure » Linux » v$ view access through shell script (10.2.0.1,rhel 4)
v$ view access through shell script [message #299779] Wed, 13 February 2008 03:11 Go to next message
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?
Re: v$ view access through shell script [message #299785 is a reply to message #299779] Wed, 13 February 2008 03:19 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Put a \ before $

Regards
Michel
Re: v$ view access through shell script [message #299786 is a reply to message #299779] Wed, 13 February 2008 03:19 Go to previous message
Mahesh Rajendran
Messages: 10707
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
Previous Topic: Problem with Oracle 10g XE in Ubuntu Gutsy Gibbon
Next Topic: Oracle 10g wants swap coould i ovveride it?
Goto Forum:
  


Current Time: Thu Mar 28 05:56:46 CDT 2024