Re: v$abc.. table names - nightmare

# 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
_at_run_some_sql_script.sql
exit;
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