14_yl
select table_name from tabs;
MERGE INTO minu_oppeained m USING uued_oppeained u ON (u.KOOD = m.KOOD)
WHEN MATCHED THEN UPDATE SET m.OPPEJOUD = u.OPPEJOUD, m.NIMETUS = u.NIMETUS
WHEN NOT MATCHED THEN INSERT (KOOD, OPPEJOUD, NIMETUS) VALUES (u.KOOD,
u.OPPEJOUD, u.NIMETUS);
select * from minu_oppeained;
rollback;
lesanne
8-------------------------------------------------------------------------------
--
create table oracle2 AS (
select
y.id idkood, y.eesnimi, y.perenimi,
x.yl1 yl1, x.yl2 yl2, x.yl3 yl3, x.k kokku,
decode
(ABS(x.k-15),x.k-15,'A','MA') arvestus
from
(
SELECT
yliopilase_id, max(ky.yl1) yl1,
max(ky.yl2) yl2, max(ky.yl3) yl3, sum(ky.k) k
from
(
select
ky.yliopilase_id,
decode(too_nr, 1, max(ky.punktid)) yl1,
decode(too_nr, 2, max(ky.punktid)) yl2,
decode(too_nr, 3, max(ky.punktid)) yl3,
max(ky.punktid) k
from
lepikult.koduylesanded ky
where
ky
annaabi.ee 
