Hi thank for ur reply.

I have another question

I need an auto decrement in oracle 11g

For example i am having a table as contacts

and column name ad ID

when i delete an row. the ID should derease by 1 automatically

can u please explain with an example