Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to create an index ?

Re: How to create an index ?

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 26 May 2005 12:49:42 -0700
Message-ID: <1117136719.57705@yasure>


Frederic wrote:
> Hi all,
>
> I have this structure to implement i18n, but I don't know how to build
> an index on my test table to fasten search on value column of this i18n
> string.
> I'm using ORA10g.
>
>
> CREATE OR REPLACE TYPE LocalizedString AS OBJECT (
> lang VARCHAR2(10),
> charset VARCHAR2(10) ,
> value VARCHAR2(4000)
> );
>
> CREATE OR REPLACE TYPE InternationalString AS VARRAY(30) OF
> LocalizedString;
>
> CREATE OR REPLACE TYPE test AS OBJECT (
> Name InternationalString
> );
>
> CREATE TABLE test OF test;
>
>
> Thanks
>
> Frédéric

Look up DOMAIN INDEX at http://tahiti.oracle.com

Also look at http://www.psoug.org
click on Morgan's Library
click on UTL_I18N
there may be some functionality there of interest to you too.

-- 
Daniel A. Morgan
Relational theory is not something that is simply a nice-to-have.
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Thu May 26 2005 - 14:49:42 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US