Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

Query dba_updatable_columns

SQL> SQL> set echo off SQL> set verify off SQL> set linesize 72 SQL> set pagesize 9999 SQL> set feedback on SQL> SQL> column view_name format a30 SQL> column column_name format a30 SQL> column i format a1 SQL> column u format a1 SQL> column d format a1 SQL> SQL> clear breaks breaks cleared SQL> break on view_name SQL> SQL> select table_name view_name,   2         column_name,   3         decode( insertable, 'YES', null, '*' ) i,   4         decode( updatable, 'YES', null, '*' ) u,   5         decode( deletable, 'YES', null, '*' ) d   6    from dba_updatable_columns   7   where rownum < 50   8  / VIEW_NAME                      Column Name                    I U D ------------------------------ ------------------------------ - - - ICOL$                          OBJ#                                BO#                                COL#                                POS#                                SEGCOL#                                SEGCOLLENGTH                                OFFSET                                INTCOL#                                SPARE1                                SPARE2                                SPARE3                                SPARE4                                SPARE5                                SPARE6 CON$                           OWNER#                                NAME                                CON#                                SPARE1                                SPARE2                                SPARE3                                SPARE4                                SPARE5                                SPARE6 UNDO$                          US#                                NAME                                USER#                                FILE#                                BLOCK#                                SCNBAS                                SCNWRP                                XACTSQN                                UNDOSQN                                INST#                                STATUS$                                TS#                                UGRP#                                KEEP                                OPTIMAL                                FLAGS                                SPARE1                                SPARE2                                SPARE3                                SPARE4                                SPARE5                                SPARE6 C_COBJ#                        OBJ# PROXY_ROLE_DATA$               CLIENT#                                PROXY#                                ROLE# 49 rows selected. SQL> SQL> prompt SQL> prompt '*' indicated action not permitted. '*' indicated action not permitted. SQL> prompt SQL> SQL> --