Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: dollar sign at end of table names
"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