Consulta3.sql

Oracle 11 |

0 B

None

0 👍

0 👎

Raw Download Clone Embed Print View

SELECT NOMBRE_TABLA, NOMBRE_PK, NOMBRE_COL_PK, TIPO_DATO_COL_PK, ORDEN_COL_PK, NUM_IND_COL
FROM
((
(SELECT cons.TABLE_NAME AS NOMBRE_TABLA, cons.CONSTRAINT_NAME AS NOMBRE_PK, cols.COLUMN_NAME AS NOMBRE_COL_PK, cols.POSITION AS ORDEN_COL_PK
FROM all_constraints cons INNER JOIN  all_cons_columns cols ON cons.constraint_name = cols.constraint_name
WHERE (cons.constraint_type = 'P') AND cons.OWNER = 'PARRANDEROS'))
FULL OUTER JOIN
 (SELECT cons.TABLE_NAME, cons.INDEX_NAME, COUNT(INDEX_NAME) AS NUM_IND_COL
FROM all_tab_columns cols, all_constraints cons
 WHERE cons.TABLE_NAME = cols.TABLE_NAME AND cons.OWNER = 'PARRANDEROS' AND (cons.constraint_type = 'P')
GROUP BY cons.TABLE_NAME,cons.INDEX_NAME)
ON NOMBRE_TABLA = TABLE_NAME)
  FULL OUTER JOIN
(SELECT TND, DATA_TP AS TIPO_DATO_COL_PK
FROM
(SELECT cons.TABLE_NAME AS TND, DATA_TYPE AS DATA_TP
FROM all_constraints cons, all_tab_columns cols
WHERE (cons.constraint_type = 'P') AND cons.OWNER = 'PARRANDEROS' AND cons.table_name = cols.table_name)) ON NOMBRE_TABLA=TND
GROUP BY NOMBRE_TABLA, NOMBRE_PK, NOMBRE_COL_PK,TIPO_DATO_COL_PK, ORDEN_COL_PK, NUM_IND_COL
ORDER BY NOMBRE_TABLA, NOMBRE_PK, TIPO_DATO_COL_PK, ORDEN_COL_PK;

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

Consulta3.sql

Comments