Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to create an index ?
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