Skip to Main Content

SQL & PL/SQL

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!

Actual length of data in a column.

rowlenFeb 27 2024

I have a column in a table that the data in the column should be 6 digits but the maximum length of the column is 15 characters. It is a alphanumeric datatype. So when I try to run a length(column_name) it gives me 15 not the actual number of characters in the column. What I am looking for is data that is greater then or less then 6 digits.

This post has been answered by Jonathan Lewis on Feb 27 2024
Jump to Answer
Comments
Post Details
Added on Feb 27 2024
7 comments
629 views