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?

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 Go to previous messageGo to next message
Michel Cadot
Messages: 68722
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 Go to previous message
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Dec 10 03:32:25 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.