Re: Special Characters in Tables and Views

From: Palooka <>
Date: Thu, 11 Jun 2009 23:25:37 +0100
Message-ID: <BvfYl.26914$Bl5.11782_at_newsfe11.ams2>

Chip Martin wrote:
> 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.

There is no special functionality; it's just a convention. Let Oracle use the dollar sign, and give your own application tables sensible names, as Mark Powell suggests.

Palooka Received on Thu Jun 11 2009 - 17:25:37 CDT

Original text of this message