|
|
|
|
|
|
| Re: # character is used in column [message #612113 is a reply to message #612111] |
Sat, 12 April 2014 03:09  |
 |
Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
As far as I can tell, # represents a "number", so column named EMP# can be read as "employee number" (or, if you prefer, "employee ID"). Of course, nothing prevents you from putting # anywhere in column name if it means something to you.
SQL> create table testo (col# number, co#lumn number);
Table created.
SQL> select table_name, column_name from user_tab_columns where column_name like '%#%';
TABLE_NAME COLUMN_NAME
------------------------------ ------------------------------
TESTO COL#
TESTO CO#LUMN
SQL> |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
