Re: v$abc.. table names - nightmare

From: Noons <wizofoz2k_at_gmail.com>
Date: Mon, 16 May 2011 17:19:02 -0700 (PDT)
Message-ID: <7a31af04-646e-4450-972e-7bd3e8d1bb94_at_22g2000prx.googlegroups.com>

On May 17, 3:55 am, neilsolent <n..._at_solenttechnology.co.uk> 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
> example!
> 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?
>
> thanks,
> Neil

backslash (\) is your friend. Received on Mon May 16 2011 - 19:19:02 CDT