Colum Name Maximum Length ?

**shandy** · 12-01-2005, 08:33 AM

Hi...
Quick question for ya, when creating a table in Oracle 9i, whats the maximum column name length you can have ?

Cheers in advance...

**oracbase** · 12-01-2005, 08:43 AM

create a test table to find out

**shandy** · 12-01-2005, 08:52 AM

I tried it just gives error, tell you what i will just keep guessing until i find right length. Thanks for all you help

**davey23uk** · 12-01-2005, 09:14 AM

30 is the limit

**shandy** · 12-01-2005, 09:46 AM

Thanks for info Davey

Cheers

Shandy

**mrchrispy** · 12-01-2005, 09:59 AM

desc user_tab_columns and look at the data type for coloum_name.

Thread: Colum Name Maximum Length ?