INSERT INTO KLIENT VALUES ((SELECT MAX(ID_K)+1 FROM KLIENT), 'Бережной Дмитрий Анатольевич', 89316893325); 
SELECT*FROM KLIENT; 
INSERT INTO ZAKAZ VALUES ((SELECT MAX(ID_Z)+1 FROM ZAKAZ), 3, '10.05.18', '23.05.18' , 
(SELECT MAX(ID_K) FROM KLIENT), 3, (SELECT (price/100)*30 FROM USLUGI WHERE ID_U=3 )); 
INSERT INTO ZAKAZ_USLUGI VALUES ((SELECT MAX(ID_Z) FROM ZAKAZ), 3); 

INSERT INTO ZAKAZ VALUES ((SELECT MAX(ID_Z) FROM ZAKAZ), 6, '10.05.18', '15.05.18', 
(SELECT MAX(ID_K) FROM KLIENT), 3, (SELECT (price/100)*30 FROM USLUGI WHERE ID_U=6 )); 
INSERT INTO ZAKAZ_USLUGI VALUES ((SELECT MAX(ID_Z) FROM ZAKAZ), 6); 
SELECT*FROM ZAKAZ; 
SELECT*FROM ZAKAZ_USLUGI; 

--предварительная стоимость по каждой услуге отдельно 
SELECT DISTINCT KLIENT.FIO, USLUGI.names, ZAKAZ.DATE_1, ZAKAZ.predvar_stoim 
FROM KLIENT, USLUGI, ZAKAZ 
WHERE KLIENT.ID_K= (SELECT MAX(ID_K) FROM KLIENT) 
AND ZAKAZ.ID_Z= (SELECT MAX(ID_Z) FROM ZAKAZ WHERE USLUGI.ID_U=3 ) 
AND ZAKAZ.predvar_stoim IN (SELECT predvar_stoim FROM ZAKAZ WHERE ID_U=3) 
UNION 
SELECT DISTINCT KLIENT.FIO, USLUGI.names, ZAKAZ.DATE_1, ZAKAZ.predvar_stoim 
FROM KLIENT, USLUGI, ZAKAZ 
WHERE KLIENT.ID_K= (SELECT MAX(ID_K) FROM KLIENT) 
AND ZAKAZ.ID_Z= (SELECT MAX(ID_Z) FROM ZAKAZ WHERE USLUGI.ID_U=6 ) 
AND ZAKAZ.predvar_stoim IN (SELECT predvar_stoim FROM ZAKAZ WHERE ID_U=6);

WITH 
USLUGI(id,names,preprice) AS (
SELECT 1,'Мойка педальки',145 from dual union all
SELECT 2,'Мойка рычажка',245 from dual union all
SELECT 3,'Выпрямление компрессии',124130 from dual
)
, KLIENT(ID_K,FIO, PHOME) AS ( 
select 22,'Бережной Дмитрий Анатольевич', 89316893325 from dual union all
select 12,'Бережной Анатолий Анатольевич', 89316893323 from dual
)
, ZAKAZ (column1, column2...) AS ( 
...
)

INSERT INTO KLIENT VALUES ((SELECT MAX(ID_K)+1 FROM KLIENT),...

create sequence s_klient_id;
INSERT INTO KLIENT VALUES (s_klient_id.nextval,...