Categorias
iiiiii
Columnas iguales en tablas
Descripcion
Evalua 4 tablas y trayendo las columnas en comun p
Nota
Se hace uso de 4 tablas ya creadas en la base de datos. y se trae las columnas en comun entre las 4.
Scrippt
--sql
with costodeCol as (
SELECT COLUMN_NAME from all_tab_columns
where table_name in ('COSTODET')
order by COLUMN_ID asc
),
prefacturacol AS (
SELECT COLUMN_NAME from all_tab_columns
where table_name in ('PREFACTURA')
order by COLUMN_ID asc
),
histnovcol AS (
SELECT COLUMN_NAME from all_tab_columns
where table_name in ('HISTNOV')
order by COLUMN_ID asc
),
novedadcol AS (
SELECT COLUMN_NAME from all_tab_columns
where table_name in ('NOVEDAD')
order by COLUMN_ID asc
)
select * from costodeCol costc
inner join prefacturacol prefc on costc.COLUMN_NAME=prefc.COLUMN_NAME
inner join histnovcol histc on histc.COLUMN_NAME=prefc.COLUMN_NAME and histc.COLUMN_NAME=costc.COLUMN_NAME
inner join novedadcol novc on novc.COLUMN_NAME=prefc.COLUMN_NAME and novc.COLUMN_NAME=costc.COLUMN_NAME and novc.COLUMN_NAME=histc.COLUMN_NAME
;