Oracle PL/SQL Tutorial/System Tables Data Dictionary/user updatable columns

30. Check if a table is updatable by query user_updatable_columns

SQL>
SQL> select column_name
  2  ,      updatable, insertable, deletable
  3  from   user_updatable_columns
  4  where  table_name = "EMPLOYEES";
no rows selected
SQL>
SQL>