How to create table indexes using Oracle functions such as UPPER(column name)?
1. In Create Index screen, under Columns tab, add a table column is selected
2. Under "Column Name/Function" column, click inside the column name field that was just aded
3. A Browse "..." button will appear. Click on this button to show Function-Based Index popup dialogue. Oracle functions such as UPPER(fieldname) can be added here.
