Re: [cx-oracle-users] speeding up TB data download

[Chuck W. <chu...@ch...>]

Thanks for your response. Can you please send me examples which query those tables (user_tab_columns, all_tab_columns or dba_tab_columns)?

---- Anthony Tuininga <ant...@gm...> wrote: 
> Hi,
> 
> Just a suggestion: avoid the parsing completely if you can do it. If
> all you're trying to do is calculate the maximum size of fields, you
> can easily write something that does this:
> 
> select max(length(<COL_NAME>)) from <TABLE_NAME>
> 
> or for numbers
> 
> select max(length(to_char(<COL_NAME>)) from <TABLE_NAME>
> 
> This sort of query is far more efficient and can be done independently
> of your extracts. You can quite easily generate all of these queries
> by reading from user_tab_columns, all_tab_columns or dba_tab_columns.
> If you need help with that, let me know.
> 
> Anthony