| Max Length for a column [message #574275] |
Tue, 08 January 2013 08:58  |
bella13
Messages: 90
Registered: July 2005
|
Member |
|
|
Hi,
I want to find the max length for a coulumn in oracle, without querying each of the columns.
Are these stats stored somewhere?
I have several fields defined as varchar2(4000). Not all of them use up 4000. Instead of querying each one ..max(coumnname) i want to explore if there is a way, i can find the max size stored somewhere? dba_tab_cols provides size of the field. is there any table that provides max used so far?
any help is appreciated.
thank you
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
