Determine a char column length

Hi!
First of all I'm a newbie on Oracle (until now I use to work on Informix, but I'm facing the possibility to be unable to do so for much longer!).

I would appreciate if someone could give me a SQL command for Ora able to determine the length of a char column.
What I intent to do I to convert for Ora the following Ifx SQL command:

select c.collength from systables t, syscolumns c where

            t.tabid = c.tabid and t.tabname = 'ctplano' and c.colname = 'conta'

TIA
Nuno C. Godinho Received on Mon Jan 20 2003 - 13:10:33 CET