Re: v$abc.. table names - nightmare
From: Matthias Hoys <anti_at_spam.com>
Date: Mon, 16 May 2011 21:08:22 +0200
Message-ID: <4dd17597$0$14244$ba620e4c_at_news.skynet.be>
Date: Mon, 16 May 2011 21:08:22 +0200
Message-ID: <4dd17597$0$14244$ba620e4c_at_news.skynet.be>
"neilsolent" <n_at_solenttechnology.co.uk> wrote in message
news:cf017e51-5ac3-4eca-a155-7dc17d3613dc_at_e21g2000vbz.googlegroups.com...
> 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
v\$database Received on Mon May 16 2011 - 14:08:22 CDT