-
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 ??
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|