Re: Special Characters in Tables and Views
From: Mark D Powell <Mark.Powell_at_eds.com>
Date: Thu, 11 Jun 2009 10:31:52 -0700 (PDT)
Message-ID: <47e220ae-2cf1-44e5-b572-a743475704ab_at_o36g2000vbi.googlegroups.com>
On Jun 11, 12:07 pm, 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
Date: Thu, 11 Jun 2009 10:31:52 -0700 (PDT)
Message-ID: <47e220ae-2cf1-44e5-b572-a743475704ab_at_o36g2000vbi.googlegroups.com>
On Jun 11, 12:07 pm, 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
I will second avoiding the use of any special characters in user object names except for the underscore. The letters A to Z with an occassional numeric digit should surfice.
IMHO -- Mark D Powell -- Received on Thu Jun 11 2009 - 12:31:52 CDT