Long/Varchar2 datatype question...Help!

From: Hope <cchln_at_NOSPAMalinga.newcastle.edu.au>
Date: Mon, 16 Nov 1998 22:02:35 GMT
Message-ID: <36509ff7.423086273@news.newcastle.edu.au>

Hello-

Excuse the newbie nature of this question, please.

I can only export 'memo' type fields from MS Access to 'long' type fields in Oracle.

I need to get the data from the 'long' fields into 'varchar2' fields so I can query it.

Please help- I cannot seem to make a query that will do this.

What I've been doing? I've tried creating two tables identical except that one has varchar2 fields where the other has long. Then I've tried to do an 'insert' query, or an 'update' query in Oracle to get the varchar2 table populated with data from the 'long' table. I can't get it to work. Please, please, some kind person, show me an example of the SQL to do this?

Thanks in advance, and sorry if this is a totally dumb question.

Hope

¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø¤º°`°º¤ø
http://www.geocities.com/PicketFence/7113/ Writing about music is like dancing about architecture. Received on Mon Nov 16 1998 - 16:02:35 CST