I am using Oracle 11g.
I have a senario like:
I need to increase auto increment id like below
00000001 00000002 00000003 00000004
For example, my table looks like below
id empid name sal 000001 10 raju 5555 000002 20 ramesh 6666 000003 30 rahul 55555
Now if I insert a record into that table the id needs to increase automatically.
How can I achieve this in a stored procedure? I have an insert statement in a stored procedure.