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 find max LENGTH of a LONG datatype column

399843Jul 25 2003 — edited Jul 27 2003

Hi all,

Unfortunately, I have to deal with a table which has a column of LONG datatype (Oracle 9i R2). I would like to know how to spot the record with the maximum length in this table, or simply put, the longest field of this column.

The sql command: "select max(length(col_name)) from my_table" doesn't work with a LONG datatype.

Any suggestions, please?

Thank you,
Sophie

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 24 2003

Added on Jul 25 2003

#general-database-discussions

1 comment

1,945 views