Re: v$abc.. table names - nightmare

From: Mladen Gogala <no_at_email.here.invalid>
Date: Mon, 16 May 2011 19:03:38 +0000 (UTC)
Message-ID: <pan.2011.05.16.19.03.37_at_email.here.invalid>

On Mon, 16 May 2011 10:55:24 -0700, 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 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

Yes. Use PHP 5.3 and "nowdoc" format which allows you to use special characters without reinterpretation. Shell is not for databases.

-- 
http://mgogala.byethost5.com

Received on Mon May 16 2011 - 14:03:38 CDT