Re: NULLS FIRST option in CREATE INDEX?

Look for Function-Based Index,

you can do something like:

create index my_index on my_table(col1,NVL(col2,'AAA'));

Jan Received on Tue Jun 17 2003 - 09:49:05 CDT