Check if a table is updatable by query user_updatable_columns : user_updatable_columns « System Tables Data Dictionary « Oracle PL/SQL Tutorial






SQL>
SQL> select column_name
  2  ,      updatable, insertable, deletable
  3  from   user_updatable_columns
  4  where  table_name = 'EMPLOYEES';

no rows selected

SQL>
SQL>








30.108.user_updatable_columns
30.108.1.Check if a table is updatable by query user_updatable_columns