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!

How to count the number of character in a column on a particular table?

512453Jan 14 2009 — edited Jan 14 2009

So I have a table called ADDRESS which has 1000's of records....

How can I find out using a SELECT which of these records have a STREET_NAME > than 30 characters?

Thanks!

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 11 2009

Added on Jan 14 2009

3 comments

3,477 views