Re: Special Characters in Tables and Views
Date: Thu, 11 Jun 2009 13:54:16 -0700 (PDT)
On Jun 11, 10:49 am, joel garry <joel-ga..._at_home.com> wrote:
> On Jun 11, 9:07 am, gazzag <gar..._at_jamms.org> wrote:
> > On 11 June, 16:48, c-mart <cmar..._at_fulcrum.net> 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
> 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: http://www.gplivna.eu/papers/naming_conventions.htm
> _at_home.com 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