Consulta2.sql

Oracle 11 |

0 B

None

0 👍

0 👎

Raw Download Clone Embed Print View

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 ;

Comments

01/01/70 12:00:00 AM UTC
Plain Text |
0 B
|
👍
/
👎
01/01/70 12:00:00 AM UTC
Plain Text |
0 B
|
👍
/
👎
01/01/70 12:00:00 AM UTC
Plain Text |
0 B
|
👍
/
👎

Pasted

Consulta2.sql

Comments