selecting field size

[ChrisQuick]

I am trying to intergrate an Oracle 8 database with another application. I've written my code to select a record from an Oracle table an populate a dialog box. I need to be able to size the text input boxes for each field based on the field size. I know I can get the field size by describing the table, but my appplication needs to get the field size via a select statement. Can anyone give me a few pointers?

 

[yaffle]

Try the all_tab_columns public view:<br>
select c.column_name, c.data_length<br>
from all_tab_columns c<br>
where c.owner = '&table_schema'<br>
and c.table_name = '&tab'<br>
and c.column_name like '&cols';<br>