-
convert a long field to char
Hi,
Could somebody please advise how to convert a long field to char?
I've been looking everywhere in metalink without too much success.
Please help. Thanks.
-
Are you sure you don't want to convert it to a clob or at least a varchar2? If you had access to Powerbuilder you could do the conversion with that. Just add a new column to the table and iterate though the table moving the data one row at a time.
You might also be able to use pl/sql. But that would involve some research.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|