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

Thread: oracle text

  1. #1
    Join Date
    Dec 2001
    Posts
    221
    can anybody tell exactly what is the usage of oracle text (formerly intermedia ) . as far as long text is concern we can store it in varchar2 with large size and even we can search for any word in that particular field using wildcard %.

    usage ?? implementation ??


  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    When you use varchar2 you are limited to use the size of 4000 characters while using intermedia, you can use LOBs and etc.

    Refer: http://technet.oracle.com/docs/produ...l2.htm#1003617

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


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