'how can i put a query in decode function?

create table ss( no number, filepath varchar2(300) )

I want to have 5 or less duplicate values of 'no' in this table

when select count(no) from ss where no=#{no} <5, insert into ss values({no},{filepath})

so duplicate values of 'no' can't be over 5. how can i do this?

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Solution	Source