Sorry, i thought this was to "easy"..

Anyway here is the whole trigger:

CREATE OR REPLACE TRIGGER dodaj_prispevek_trigger AFTER INSERT ON PRISPEVKI

FOR EACH ROW

DECLARE

st_prispevka NUMBER;

st_odobritve NUMBER;

max_clan NUMBER;

st_clana NUMBER;

BEGIN

-- dobimo id...

Nevermind.. I solved the problem..

Thanks for help! Yep, TOP invokes an error, so I'm sure Oracle doesn't support TOP... Nevertheless, I solved a problem... Thank again!

Ok i managed it with ROWNUM = 1 😉

QUREY:

SELECT UDE_IDUDELEZENCA FROM

(

SELECT UDE_IDUDELEZENCA

FROM PRISPEVKI

WHERE ODOBREN = 0

GROUP BY PRISPEVKI.UDE_IDUDELEZENCA

ORDER BY COUNT(PRISPEVKI.UDE_IDUDELEZENCA) DESC

)

WHERE ROWNUM = 1;

Maybe is the problem with Oracle?

Thanks again...

Thanks for advice, but in line 1 (SELECT TOP 1 UDE_IDUDELEZENCA)

[UDE_IDUDELEZENCA is X in upper table] I get an error:

SELECT TOP 1 UDE_IDUDELEZENCA FROM

...