Getting scale & precision on calculated columns

Does anyone know how to determine the precision and scale of a number column after a function has been applied to it?

When I select max(this_id) the precision and scale are lost and I can no longer tell if the number contained a fractional part or was an integer. Same question for any calculated column.

I'm using 4th level dynamic sql and extracting the precision and scale with the sqlprc() function. Simple columns are no problem. Numeric columns with functions applied have null scale and precision.

I tried creating a view with calculated columns, and user_tab_columns also had null data_scale and data_precision.

Thanks for any help on this you can give!

+------------------------------------------------------------------------+


| Mari Mortell, DBA                       email:  mortell_at_esosun.css.gov |

| SAIC Geophysics, MS A2-F                                               |

| 10210 Campus Point Drive                 phone:  (619)458-2771         |


| San Diego, CA  92121                       fax:  (619)458-4993         |

 +------------------------------------------------------------------------+