Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

What's the significance of # in SQL?

I have the following code to create an object type in Oracle (PL??)

CREATE OR REPLACE TYPE STAFF_T as OBJECT(Staff_ID# NUMBER, Person PERSON_T); \

I'd like to know what is the significance of the # appended to the Staff_ID variable in the declaration?

like image 522
Dark Star1 Avatar asked May 05 '11 18:05

Dark Star1


1 Answers

No special meaning.

Oracle allows using $, _ and # in identifiers, just like any other alphanumeric characters, but the identifier should begin with an alpha character (a letter).

like image 96
Quassnoi Avatar answered Oct 08 '22 10:10

Quassnoi