ASKER
SELECT
DISTINCT pol_num
,decode(form_num,'F350.0','Y') F350_0
,decode(form_num,'F353.0','Y') F353_0
,decode(form_num,'F353.1','Y') F353_1
,decode(form_num,'F555.5','Y') F555_5
FROM
(
select a.POL_NUM,a.FORM_NUM FROM TABLE_A a
UNION ALL
SELECT b.POL_NUM,b.FORM_NUM FROM TABLE_B b
UNION ALL
SELECT c.POL_NUM,c.FORM_NUM FROM TABLE_C c
)a
SELECT
pol_num
,MAX(decode(form_num,'F350.0','Y')) F350_0
,MAX(decode(form_num,'F353.0','Y')) F353_0
,MAX(decode(form_num,'F353.1','Y')) F353_1
,MAX(decode(form_num,'F555.5','Y')) F555_5
FROM
(
select a.POL_NUM,a.FORM_NUM FROM TABLE_A a
UNION ALL
SELECT b.POL_NUM,b.FORM_NUM FROM TABLE_B b
UNION ALL
SELECT c.POL_NUM,c.FORM_NUM FROM TABLE_C c
)a
GROUP BY pol_num
| POL_NUM | F350_0 | F353_0 | F353_1 | F555_5 |
|---------|--------|--------|--------|--------|
| P-5283 | (null) | (null) | Y | (null) |
| P-4404 | Y | Y | Y | Y |
| P-2613 | (null) | (null) | (null) | Y |
| P-9022 | (null) | (null) | (null) | Y |
| P-0600 | Y | Y | Y | (null) |
| P-6171 | Y | (null) | (null) | (null) |
| P-6533 | Y | (null) | (null) | (null) |
| P-0603 | Y | Y | (null) | (null) |
ASKER
Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.
TRUSTED BY
ASKER
but it's not quite right;
select distinct pol_num,
decode(form_num,'F350.0','
decode(form_num,'F353.0','
decode(form_num,'F353.1','
decode(form_num,'F555.5','
from simdata.table_a
;
select distinct pol_num,
decode(form_num,'F350.0','
decode(form_num,'F353.0','
decode(form_num,'F353.1','
decode(form_num,'F555.5','
from simdata.table_b;
select distinct pol_num,
decode(form_num,'F350.0','
decode(form_num,'F353.0','
decode(form_num,'F353.1','
decode(form_num,'F555.5','
from simdata.table_c;