Consulta2.sql

SELECT NOMBRE  AS NOMBRE_TABLA ,TIPO  AS TIPO_DATO_COL , NVL(NUMERO_DE_RESTRICCIONES, ) ,NUMERO_DE_COLUMNAS
FROM (
SELECT TABLE_NAME AS NOMBRE  ,DATA_TYPE AS TIPO  ,COUNT(*) AS NUMERO_DE_COLUMNAS
FROM all_tab_columns
WHERE OWNER = 'PARRANDEROS'
GROUP BY DATA_TYPE,TABLE_NAME
ORDER BY TABLE_NAME)
FULL OUTER JOIN (
SELECT TABLE_NAME AS NOMBRE  ,DATA_TYPE AS DATOS  ,COUNT(*) AS NUMERO_DE_RESTRICCIONES
FROM ALL_TAB_COLUMNS atc
WHERE OWNER = 'PARRANDEROS' AND atc NULLABLE = 'N'
GROUP BY DATA_TYPE, TABLE_NAME
ORDER BY TABLE_NAME )
ON ( NOMBRE  = NOMBRE  AND TIPO  = DATOS  )
ORDER BY NOMBRE ;