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!

How to check table column field length after being converted into unicode

BinoyFeb 27 2011 — edited Feb 28 2011

Hi,

I have an 11gr2 Peoplesoft 850 DB running on RHEL5 that was just recently converted to unicode. After converting the the database into unicode, the length is now returning the bytes value instead of the actual field length when checked

desc <table_name>

<column_name> <datatype><(column field length)>

to:

<column_name> <datatype><(length in bytes)>

which is 3x the column field length.

Is there a way I can check the length of the column without extracting the definition of the table itself?

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 28 2011

Added on Feb 27 2011

#general-database-discussions

2 comments

529 views