OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » create table

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

create table [message #60593]

Wed, 18 February 2004 08:53

sidd
Messages: 130
Registered: May 2003

Senior Member

What are the disadvantages of naming fields with �#� signs like

�

SQL> create table tst_tabl (emp_id number(10), ename# varchar2(20), eaddr varchar2(10));

�

Table created.

�

SQL> desc tst_tabl

�Name�� Null?�� Type

�----------------------------------------- -------- ----------------------------

�EMP_ID�� NUMBER(10)

�ENAME#�� VARCHAR2(20)

�EADDR�� VARCHAR2(10)

�

Are there any disadvantages please let me know ?

Thanks

Regards

�

Report message to a moderator

Re: create table [message #60596 is a reply to message #60593]

Wed, 18 February 2004 09:51

andrew again
Messages: 2577
Registered: March 2000

Senior Member

Oracle do it all the time in the data dictionary. I don't know of any problems. I would stick to whatever your standard is though.

Report message to a moderator

Re: create table [message #60597 is a reply to message #60593]

Wed, 18 February 2004 10:22

Thiru
Messages: 1089
Registered: May 2002

Senior Member

Saw this on the documentation
"Nonquoted identifiers can contain only alphanumeric characters from your database character set and the underscore (_), dollar sign ($), and pound sign (#). Database links can also contain periods (.) and "at" signs (@). Oracle Corporation strongly discourages you from using $ and #. "

I know Oracle uses $ and # all the time for its dictionary tables.

its upto you :)

-Thiru

Report message to a moderator