Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / System Tables Data Dictionary

 

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>