Re: Oracle7 SQLPLUS: question about CHAR and VARCHAR
From: Doug DeBono <70412.1215_at_CompuServe.COM>
Date: 20 Jan 1995 15:35:34 GMT
Message-ID: <3fol86$223$1_at_mhadf.production.compuserve.com>
Date: 20 Jan 1995 15:35:34 GMT
Message-ID: <3fol86$223$1_at_mhadf.production.compuserve.com>
I would suggest you use VARCHAR2 instead of VARCHAR. I suspect you are porting from V6 to V7.x. I would suggest you create a new table with the columns in the same order as the old table and change data columns from CHAR to VARCHAR2.
Once you have done this do an INSERT INTO NEW TABLE SELECT * FROM OLD_TABLE.
Rename the tables and check things out.
\exit
Received on Fri Jan 20 1995 - 16:35:34 CET