Re: v$abc.. table names - nightmare

From: Mladen Gogala <>
Date: Mon, 16 May 2011 19:03:38 +0000 (UTC)
Message-ID: <>

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.

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

Original text of this message