Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Get maximum length of varchar-field

448590Jan 26 2009 — edited Jan 26 2009

Hallo,

I have a question. I have a table with different column, one of these is a varchar2-column.
Because I didn't know how long the field could be I had set to varchar2(4000). Now I want to reduce it to the maximum it really has.

So I want to implement a script that goes over all tables and all varchar2-field and gets the maximum size.
My question: is there a function how I can get the maximum size of varchar2-field?

Thanks, Jade

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 23 2009

Added on Jan 26 2009

#general-database-discussions

4 comments

4,790 views