Re: Special Characters in Tables and Views
From: gazzag <gareth_at_jamms.org>
Date: Thu, 11 Jun 2009 09:07:56 -0700 (PDT)
Message-ID: <c4606c58-0820-4c00-9728-f0a7c20fc7b9_at_r37g2000yqd.googlegroups.com>
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!
Date: Thu, 11 Jun 2009 09:07:56 -0700 (PDT)
Message-ID: <c4606c58-0820-4c00-9728-f0a7c20fc7b9_at_r37g2000yqd.googlegroups.com>
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 Received on Thu Jun 11 2009 - 11:07:56 CDT