user_ind_columns « System Tables Views « Oracle PL / SQL






  1. Oracle PL / SQL
  2. System Tables Views
  3. user_ind_columns
1.Decode column position
2.Query user_indexes and user_ind_columns table
3.user_indexes join user_ind_columns ic using (table_name,index_name)
4.Check index column and contraints for just created table