Skip to Main Content
Forums

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!

finding column data length

626015Mar 3 2008 — edited Mar 3 2008
In sql server I can do

Select Max(DATALENGTH(col)) FROM Table

to get max datalength of a column. Is there a similiar function in oracle.

Also, I need to go through all rows of all tables of a db, is there a possible way to to that as well?

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 31 2008
Added on Mar 3 2008
12 comments
63,912 views