How do I convert LONG to VARCHAR2?
From: Al Salvador <alsalvador_at_home.com>
Date: Fri, 04 Feb 2000 06:13:36 GMT
Message-ID: <389A6E4E.562D2C2_at_home.com>
Date: Fri, 04 Feb 2000 06:13:36 GMT
Message-ID: <389A6E4E.562D2C2_at_home.com>
[Quoted] I have a table with a field defined as LONG. It has regular text in it (none greater than 2000 characters). I want to assign it to a VARCHAR2 variable in PL/SQL so I can save it as a VARCHAR2 field in another table. If I can't do this in PL/SQL, can I use some sort of export/import to get a LONG field into a VARCHAR2 field? Anyone have any ideas? Thanks. Received on Fri Feb 04 2000 - 07:13:36 CET