Re: v$abc.. table names - nightmare

From: Sybrand Bakker <>
Date: Mon, 16 May 2011 23:25:07 +0200
Message-ID: <>

On Mon, 16 May 2011 10:55:24 -0700 (PDT), neilsolent <> wrote:

>Why oh why did Oracle decide to make table names with special symobols
>in them, like v$database?
>This makes it a nightmare in shell scripts wrapping sqlplus for
>Try writing a shell script that su's to oracle and executes sqlplus to
>get data from v$database..
>Is there any workaround to avoid the dollars, such as aliases?

Many attributes of v$database, which is for privileged users, are available unprivileged via sys_context('userenv','<attribute>') for instance 'db_name".
Usually to know that some manual reading is required. Most people don't read documentation, and this results in unjustified rants like you posted above.

Sybrand Bakker
Senior Oracle DBA Received on Mon May 16 2011 - 16:25:07 CDT

Original text of this message