<div>
months_between(trunc(sysda<wbr />te),join_d<wbr />ate) in (12,24,36,48,60...) &gt;= &nbsp;then pay one more month basic sal along with the salary.<br />
<br />
There are many ways to do this. That is just one method.<br />

</div>


months_between(trunc(sysdate),join_date) in (12,24,36,48,60...) >=  then pay one more month basic sal along with the salary.

There are many ways to do this. That is just one method.


<div>
where mod(months_between(trunc(s<wbr />ysdate,'mm<wbr />'),trunc(j<wbr />oindate,'m<wbr />m)),12) = 0
</div>


where mod(months_between(trunc(sysdate,'mm'),trunc(joindate,'mm)),12) = 0

<div>
Missing a quote - <br />
where mod(months_between(trunc(s<wbr />ysdate,'mm<wbr />'),trunc(j<wbr />oindate,'m<wbr />m')),12) = 0 
</div>


Missing a quote -
where mod(months_between(trunc(sysdate,'mm'),trunc(joindate,'mm')),12) = 0

<div>
<div class="content wysiwyg-content">
Dear all<br />
In my employee data i have the following<br />
joindate, basic salary. After every year from join date i have to pay one basic salary along with the monthly salary. <br />
<br />
When preparing the monthly salary, what is the best method to &nbsp;find out which are the people basic salary is due on that particular month. <br />
<br />

</div>
</div>


Dear all
In my employee data i have the following
joindate, basic salary. After every year from join date i have to pay one basic salary along with the monthly salary. 

When preparing the monthly salary, what is the best method to  find out which are the people basic salary is due on that particular month. 



how to find due date

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.