A Simple Structure Table

• create table COMPOUND (

• id number not null,

• smiles varchar2(4000),

• molecular_weight float,

• molecular formula varchar2(20),

• primary key (id)

• );

• create index COMPOUND_idx1

• on COMPOUND(smiles)

• indextype is c$dcischem.ddexact;

• create index COMPOUND_idx2

• on COMPOUND(smiles)

• indextype is c$dcischem.ddblob;

Notes: