ALLUPDATABLECOLUMNS -Definition - Oracle Views, Sequences, and Synonyms

Q.  Which view Shows all columns in all tables and views accessible to the user that are modifiable in the UPDATABLE_COLUMNS VIEWS?
- Published on 29 Jul 15

a. DBA_UPDATABLE_COLUMNS
b. ALL_UPDATABLE_COLUMNS
c. USER_UPDATABLE_COLUMNS
d. None of the above

ANSWER: ALL_UPDATABLE_COLUMNS
 

    Discussion

  • Nirja Shah   -Posted on 30 Sep 15
    - The views described in the following table can assist you to identify inherently updatable join views.

    DBA_UPDATABLE_COLUMNS
    - Shows all columns in all tables and views that are modifiable.

    ALL_UPDATABLE_COLUMNS
    - Shows all columns in all tables and views accessible to the user that are modifiable.

    USER_UPDATABLE_COLUMNS
    - Shows all columns in all tables and views in the user's schema that are modifiable.

Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)