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