Re: Special Characters in Tables and Views

From: Chip Martin <>
Date: Thu, 11 Jun 2009 13:54:16 -0700 (PDT)
Message-ID: <>

On Jun 11, 10:49 am, joel garry <> wrote:
> On Jun 11, 9:07 am, gazzag <> wrote:
> > On 11 June, 16:48, c-mart <> wrote:
> > > Greetings All,
> > > Just wondering about the significance of table names and views with a
> > > dollar sign $.  Is there a special case in where you would want to
> > > build a table with a '$'
> > > Sorry if this seems elementary,  I tried to find the answer on
> > > metalink and online but to no avail.
> > > Cheers!
> > $ views are internal to Oracle and owned by SYS.  I would suggest that
> > you don't create your own objects with "$" in their names.
> > HTH
> > -g
> Speculation here, but I've always had the idea this came from the PDP
> and VMS worlds, where $ meant things - in RSTS it meant the privileged
> user, in VMS it was a separator in system routine names, separating
> the service and function parts of the routines.  So it became a nono
> for people to use, in case they screwed up the system with their own
> routines because of a naming collision, but of course, every
> programmer secretly wants people to think they are an internals
> expert.
> There are a number of naming convention docs floating about, as well
> as an old joke on OTN where someone claimed to have an Oracle doc, and
> for years people would ask to be sent it, posting their email online.
> This seems well done:
> jg
> --
> is bogus.
> "What are u gonna do fire me for volunteering for the special olympics
> hahaha ur crazy . . . ”  - Carrie Prejean, fired as Miss California
> for cause.  (quote from email to Keith Lewis, executive director of
> the Miss California USA)

Thanks all, my question had more to do with the significance or relevance of the dollar sign more than anything else. There must be a reason for it, I think Joel is on to something but from his response, it was just speculation.

I was playing around with the model clause in the SH schema provided in 10g, noticed that some of the tables (and even indexes) had $ in the names (DR$SUP_TEXT_IDX$N), while I have seen and used V$ tables/ views before I just always assumed that they were reserved for internal purposes only and just left it at that. When I saw the five tables and one index in SH it just got me thinking why the '$'.

Thanks again. Received on Thu Jun 11 2009 - 15:54:16 CDT

Original text of this message