Re: Special Characters in Tables and Views

From: joel garry <>
Date: Thu, 11 Jun 2009 10:49:18 -0700 (PDT)
Message-ID: <>

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.
> -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:


-- 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)
Received on Thu Jun 11 2009 - 12:49:18 CDT

Original text of this message