Re: v$abc.. table names - nightmare

From: onedbguru <onedbguru_at_yahoo.com>
Date: Tue, 17 May 2011 09:43:14 -0700 (PDT)
Message-ID: <58ce2779-6f73-4ad7-a010-8730c180d75e_at_w10g2000yqa.googlegroups.com>



On May 17, 9:49 am, neilsolent <n..._at_solenttechnology.co.uk> wrote:
> On May 17, 1:19 am, Noons <wizofo..._at_gmail.com> wrote:
>
> > 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.
>
> Yes but it's not just as simple as one backslash.
> My Perl script is calling sqlplus via su (to switch to Oracle) - 7
> backslahses needed v\\\\\\\$database      !!
> Try it and see.. that's what I mean by a nightmare.
> If they could just refrained from naming tables with $ symbols..  :-)
>
> I could just put the script in a file, but not very neat.
> Using other tools means other problems - more dependencies to cater
> for.
> Oh well, thanks anyway..

Just an FYI - those table names have been that way since Version 1. put your sql in a script and call the script.. much easier than what you are trying to do... been there, done that. Received on Tue May 17 2011 - 11:43:14 CDT

Original text of this message