v$abc.. table names - nightmare
From: neilsolent <n_at_solenttechnology.co.uk>
Date: Mon, 16 May 2011 10:55:24 -0700 (PDT)
Message-ID: <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?
Date: Mon, 16 May 2011 10:55:24 -0700 (PDT)
Message-ID: <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
Received on Mon May 16 2011 - 12:55:24 CDT