Re: dollar sign at end of table names

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Wed, 1 Feb 2006 09:34:03 -0500
Message-ID: <Z4WdncRcwbRDW33eRVn-gQ@comcast.com>

"AF" <neXwsXXaXlXXXaXkXsa_at_nxXXtgX.nXXet> wrote in message news:43e094c9_at_news.deckpoint.ch...
>
> Hi everyone!
> Our programmer recently left and I need to do some development
> on our application. It is connected to an oracle database.
>
> I can see that some table names end with a dollar sign. Could some
> one tell me what it means ? Thank you,
>
> antoine
>

means nothing to oracle (except in the SYS tables sybrand refers to, and that is simply a naming convention, means nothing to the SQL processing)

check out the SQL Reference manual for object naming conventions & legal names -- your recently departed comrade might have used the $ character as part of a naming convention that indicates something to the programmer (kind of like using _PK at the end of a contraint name -- just an arbitrary convention)

++ mcs Received on Wed Feb 01 2006 - 08:34:03 CST