<div>
Hello mcanetvenkat,<br />
<br />
you have to use sequence for this<br />
<br />
HTH<br />
<br />
I
</div>


Hello mcanetvenkat,

you have to use sequence for this

HTH

I

<div>
You could create a sequence and use the sequence directly in your insert statement<br />
<br />
CREATE SEQUENCE emp_seq START WITH 1 INCREMENT BY 1; <br />
<br />
&nbsp; INSERT INTO emp( empid, empname, empaddress )<br />
&nbsp; VALUES ( emp_seq.NEXTVAL, 'Name','Address' );
</div>


You could create a sequence and use the sequence directly in your insert statement

CREATE SEQUENCE emp_seq START WITH 1 INCREMENT BY 1;

  INSERT INTO emp( empid, empname, empaddress )
  VALUES ( emp_seq.NEXTVAL, 'Name','Address' );

<div>
Force accepted<br />
<br />
AnnieMod<br />
Cleanup Admin
</div>


<div>
<div class="content wysiwyg-content">
<br />
How to auto increment in pl sql collumn (LIKE SQL we have identity like wise in pl sql what ?)<br />
<br />
EXample i have emp table i have three column empid,empname,empaddress<br />
<br />
I need to this empid column autoincerment.<br />
<br />
In my pl sql .<br />
<br />

</div>
</div>



How to auto increment in pl sql collumn (LIKE SQL we have identity like wise in pl sql what ?)

EXample i have emp table i have three column empid,empname,empaddress

I need to this empid column autoincerment.

In my pl sql .



How to auto increment in pl sql collumn (LIKE SQL we have identity like wise in pl sql what ?)

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.