DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    May 2000
    I have a table where I need to have columns with multiple LONG datatype. But owing to the limitation of not having more than one LONG column per table, is there a workaround to this without creating additonal tables?

    I also knew that I can use LONG RAW but again that gives me only 2 columns. I have a requirement for more than that.


  2. #2
    Join Date
    Dec 2000
    Ljubljana, Slovenia
    Switch to Oracle8 if you are not allready there and use CLOBs, BLOBs, or BFILEs instead. There is no way you could use more than one of LONG types in a table.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  3. #3
    Join Date
    May 2000
    Thanks for the reply. It was helpful. Yes I am on Oracle 8i so I can use all of these.

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.