Creating Normal Index

scott>create index ind_normal on salgrade(grade);
scott>select a.table_name,a.index_name,a.index_type,b.column_name from user_indexes a,user_ind_columns b where a.table_name=b.table_name;