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!

Find the character length of a column value in Oracle DB

User_19BPUAug 8 2017 — edited Aug 8 2017

Hi,

I need to find whether the character length of a column value "cust name" is greater than 20 or not. The data type is varchar2(250), only i need to filter the cust name column value length > 20 . Since there are millions of records available, I cant do it manually , please let me know whether we can filter this using SQL query?

Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 5 2017

Added on Aug 8 2017

#general-database-discussions

3 comments

2,186 views