Hi,
I need a simple script to create an index with multiple column if not exit, the only parameter that I know is table_name and column_name.
I have an idea but it's complicate spaecialy when we check for an index with 10 column!!
Declare
i integer;
i:=0;
Begin
select count(*) into i
from USER_IND_COLUMNS
where column_name=<column name1>
and table_name=<table_name>
and index_name in (select index_name
from USER_IND_COLUMNS
where column_name= <column_name2>
and table_name=<table_name>);
if i=0 then
create index <balbala> .....
end if;
i:=0;
.
.
.
end;
Thanks
Edited by: vittel on Mar 25, 2009 12:18 PM