OraFAQ Forum: Server Administration » Maximum column name length??

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

Tue, 01 July 2003 02:00

bei
Messages: 4
Registered: November 2001

Junior Member

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

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.

Tue, 01 July 2003 03:42

Vikas Gupta
Messages: 115
Registered: February 2002

Senior Member

You can go upto 30 chars.

Regards,

Vikas Gupta.

Tue, 01 July 2003 03:49

krishna
Messages: 141
Registered: October 1998

Senior Member

Tue, 01 July 2003 05:44

bei
Messages: 4
Registered: November 2001

Junior Member

Thanks very much for the replies :) !!

Previous Topic:	StoredProcedure
Next Topic:	Database Mounting

Goto Forum:

]

Current Time: Thu Jan 16 19:05:08 CST 2025