DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: convert a long field to char

Hybrid View

  1. #1
    Join Date
    Jul 2001
    Location
    Montreal
    Posts
    222

    Question 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.

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    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
  •  


Click Here to Expand Forum to Full Width