Re: v$abc.. table names - nightmare

From: John Hurley <>
Date: Mon, 16 May 2011 16:18:16 -0700 (PDT)
Message-ID: <>


# Why oh why did Oracle decide to make table names with special
symobols in them, like v$database?

Been like that for a long long time ...

# This makes it a nightmare in shell scripts wrapping sqlplus for
example! Try writing a shell script that su's to oracle and executes sqlplus to get data from v$database..

Not a nightmare at all.

One approach is to put your sql inside a file and then execute that file from sqlplus.

cd /to_some_location

export ORACLE_SID=whatever
sqlplus / as sysdba << EOF
# Is there any workaround to avoid the dollars, such as aliases?

What are you trying to do exactly? Received on Mon May 16 2011 - 18:18:16 CDT

Original text of this message