Home » SQL & PL/SQL » SQL & PL/SQL » A $ sign in PLSQL variables names or procedure name
A $ sign in PLSQL variables names or procedure name [message #203297] Tue, 14 November 2006 12:12 Go to next message
wojtekw
Messages: 4
Registered: November 2006
Location: POLAND
Junior Member
hi

Is there someone who explain me for what is a $ sign in variable names or proc name for example NC$BLABLA

i am not experienced in a plsql

thanks
wojtekw

ps.
sorry for my english
Re: A $ sign in PLSQL variables names or procedure name [message #203320 is a reply to message #203297] Tue, 14 November 2006 15:24 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Nothing. It is just another character which is allowed to be used for naming purposes, along with alphanumerics, a pound (#) and underscore (_) signs.

However, Oracle corp. strongly discourages you to use $ and #.
Re: A $ sign in PLSQL variables names or procedure name [message #203497 is a reply to message #203320] Wed, 15 November 2006 05:26 Go to previous messageGo to next message
wojtekw
Messages: 4
Registered: November 2006
Location: POLAND
Junior Member
thanks a lot

it was so simple, but i wasn't found any docs about it

thx
wojtekw
Re: A $ sign in PLSQL variables names or procedure name [message #203499 is a reply to message #203497] Wed, 15 November 2006 05:34 Go to previous message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Oracle documentation can be found at Tahiti or Oracle Technology Network.

For your convenience, here is a link to Schema Object Names and Qualifiers.
Previous Topic: Select non-existing combinations
Next Topic: Problem with in operator
Goto Forum:
  


Current Time: Fri Dec 09 09:47:30 CST 2016

Total time taken to generate the page: 0.10524 seconds