Oracle -Table Columns Report Etiketli Yazılar

Oracle – Table Columns Report

SELECT   a.owner,    table_name  || ' '  || object_type table_name, column_name,
         data_type, data_length, DECODE (nullable, 'N', 'NO', 'YES') nullable
    FROM dba_tab_columns a, dba_objects b
   WHERE a.owner NOT IN ('SYS', 'SYSTEM')
   AND a.owner = UPPER ('Xtablespace')
     AND a.owner = b.owner
     AND a.table_name LIKE UPPER ('Xtablename')
     AND a.table_name = b.object_name
     AND object_type IN ('TABLE', 'VIEW', 'CLUSTER')
ORDER BY owner, object_type, table_name, column_id