Thursday, July 18, 2013

ORACLE - Get updatable columns of a table

If you want check if a table in your Oracle database can be update, insert or delete, you can use the following query:

SELECT * FROM USER_UPDATABLE_COLUMNS WHERE TABLE_NAME='STUDENTS';


And you'll get something like this: