<div>
<div class="content wysiwyg-content">
i have a requirement of getting autonumbering like for ex.as below. it should start from one when the dept number changes. thanks.<br />
<br />
Dept NO. Ename<br />
10 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1.test<br />
10 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2.test<br />
10 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3.test<br />
20 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1.test<br />
20 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2.test<br />
20 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3.test
</div>
</div>


i have a requirement of getting autonumbering like for ex.as below. it should start from one when the dept number changes. thanks.

Dept NO. Ename
10             1.test
10             2.test
10             3.test
20             1.test
20              2.test
20              3.test

oracle function

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.