How to create an index ?

From: Frederic <fh_at_ionicsoftDOTcom>
Date: Thu, 26 May 2005 16:57:17 +0200
Message-ID: <4295e3dc$0$1815$6c56d894@reader0.news.be.easynet.net>

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 Received on Thu May 26 2005 - 09:57:17 CDT