Consultas sobre metadata en Oracle

 ———————————————————-
–ALL_TABLES tablas del esquema
———————————————————-
SELECT * FROM ALL_TABLES
 WHERE (table_name Like Upper(‘%callejero%’) OR 1=2)
ORDER BY table_name

———————————————————-
–ALL_TAB_COLUMNS columnas de las tablas
———————————————————-
SELECT * FROM ALL_TAB_COLUMNS
 WHERE (table_name Like Upper(‘%callejero%’) OR 1=1)
       AND (column_name Like Upper(‘%calle%’)    OR 1=2)
ORDER BY table_name, column_name

———————————————————-
–ALL_VIEWS vistas del esquema 
———————————————————-
SELECT *FROM ALL_VIEWS
 WHERE (view_name Like Upper(‘%v_callej%’)   OR 1=2)
ORDER BY view_name

———————————————————-
–ALL_VIEW_COLUMNS ?! columnas de las vistas
———————————————————-
SELECT o.object_name view_name
               ,c.column_name
               ,c.data_type
               ,c.data_length
               ,c.data_precision
               ,c.data_scale
  FROM ALL_OBJECTS o
JOIN ALL_TAB_COLUMNS c ON ( c.table_name = o.object_name)
WHERE o.object_type = ‘VIEW’
      AND (Upper(o.object_name) Like Upper(‘%v_ejes_calle%’)       OR 1=2)   –view name
      AND (Upper(c.column_name) Like Upper(‘%cod_calle%’)          OR 1=1) 
ORDER BY o.object_name, c.column_name