Layout problems in SQL Worksheet

     Hi all!

  The DBMS used in my company is the Oracle 7.3. We have here some tables which has a column datatype 'varchar2(1)'. On SQL Worksheet or on SQL Plus when I run a select query on these tables it truncates the column name which is 'varchar2(1)' to one character. More generally, it truncates the column name thas has datatype 'varchar2(n)' to n characters. But I don't want this; I would like to specify the column length. Is there a way to do that?

          Thanks in advanced,

                Carlos

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet