Oracle's "number" field length at run-time?

[Chris Botha]

I am filling a DataTable using an OleDbDataAdapter from an Oracle database.
Setting the MissingSchemaAction to "AddWithKey" on the data adapter works
for text fields - the MaxLength for the text columns are filled correctly.
How the heck do I get the definition of a NUMBER field, thus the precision
and scale? Same applies to an SQL Server DECIMAL data type.

Thanks.

 

[Jim Brandley]

The following select will doit:

Select column_name, data_type, data_length, data_precision, data_scale,
nullable, data_default
From dba_tab_columns
Where owner = 'Whatever your owner is' and table_name = :table_name order
by LOWER(column_name);

 

[Chris Botha]

Hi Jim, thanks, it works great.

The following select will doit:

Select column_name, data_type, data_length, data_precision, data_scale,
nullable, data_default
From dba_tab_columns
Where owner = 'Whatever your owner is' and table_name = :table_name order
by LOWER(column_name);