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

Thread: datatype

  1. #1
    Join Date
    Jan 2000
    Posts
    6

    Lightbulb

    Hi all,

    I have a table called Result. Which holds id & result columns. Id column is integer & result column is varchar(50). I want to change datatype of column result to make it memo field.
    In Sql-server you can make column datatype to text which is memo filed. How I can do it in oracle?

  2. #2
    Join Date
    Jan 2001
    Posts
    28
    To the extent of my knowledge, you have a datatype called LONG in oracle, with size upto 2Gb in length. But you can have only one LONG datatype per table and cannot use it in joins, subqueries, functions, expressions, where clauses or indexes.
    - Mayur.

  3. #3
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    If you are using Oracle 8.* then you can simply change the upper limit of your RESULT column to VARCHAR2(4000), thus making it capable of storing up to 4000 bytes of data. Upper limit for VARCHAR2 is 4000 bytes for 8.0 and higher, 2000 bytes for versions 7.*.

    If this is not enough for your RESULT column then use LOBs (much more recomended than LONGs) in Oracle8.* or LONG in 7.*.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  4. #4
    Join Date
    Jan 2000
    Posts
    6

    thanks

    Thanks alot. I used Lob datatype.

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