OraFAQ Forum: Server Administration => Maximum column name length??

Home » RDBMS Server » Server Administration » Maximum column name length??

Maximum column name length?? [message #57692]

Tue, 01 July 2003 02:00

bei
Messages: 4
Registered: July 2003

Junior Member

Does anyone know if there is a limit to how long a column name can be in a table?

Re: Maximum column name length?? [message #57696 is a reply to message #57692 ]

Tue, 01 July 2003 03:34

psmyth
Messages: 81
Registered: October 2002

Member

dba_tab_columns shows the colmn_name field to be defined as a varchar2(30)... so from that I would deduce that the limit is 30 characters.

Re: Maximum column name length?? [message #57697 is a reply to message #57692 ]

Tue, 01 July 2003 03:42

Vikas Gupta
Messages: 115
Registered: May 2002

Senior Member

You can go upto 30 chars.

Regards,

Vikas Gupta.

Re: Maximum column name length?? [message #57698 is a reply to message #57696 ]

Tue, 01 July 2003 03:49

krishna
Messages: 134
Registered: March 2002

Senior Member

Re: Maximum column name length?? [message #57705 is a reply to message #57698 ]

Tue, 01 July 2003 05:44

bei
Messages: 4
Registered: July 2003

Junior Member

Thanks very much for the replies :) !!

Previous Topic:	StoredProcedure
Next Topic:	Database Mounting

Goto Forum:

]

Current Time: Sat Nov 22 12:07:18 CST 2008

Total time taken to generate the page: 0.02038 seconds

.:: Forum Home :: Blog Home :: Wiki Home :: Contact :: Privacy ::.