Multiple LONG columns
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Multiple LONG columns

  1. #1
    Join Date
    May 2000
    Posts
    50
    Hi,
    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.

    -Prasad.

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    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
    Posts
    50
    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