Re: Oracle7 SQLPLUS: question about CHAR and VARCHAR
From: Ravi Kumar <rkumar_at_cix.compulink.co.uk>
Date: Thu, 26 Jan 1995 20:00:38 GMT
Message-ID: <D313L2.1qF_at_cix.compulink.co.uk>
Date: Thu, 26 Jan 1995 20:00:38 GMT
Message-ID: <D313L2.1qF_at_cix.compulink.co.uk>
I don't think your problem is anything to do with datatypes, or datalengths. It is to do with formatting the output of select in sql*plus.
try using the column command in conjunction with column aliasing to format your data. Refer to sqlplus manual for further help. The following example may of some help.
sql> column col1 format a10 sql> select surname||' '||forename col1 sql> from table_name;
Ravi Kumar Received on Thu Jan 26 1995 - 21:00:38 CET