yes surely you can have a numeric value generated automatically by a database object called sequence. For this you have to use the standard syntax of
create sequence seq1
start with 1
increment by 1;
This will create a value each time incremented by one. Whenyou want to use this in the table,
you can access it with 'extval' psudocolumn as below.
insert into tabname values(seq1.nextvale,......restof the values);
You can refer to documentation for a detailed info about sequences adn the rest of the clauses while creating the sequences. Also pls refer to data dictionry called user_equences after you create the seqence.
Remember that the sequence values can not be rolledback so if yourollback the insert stmt, you are loosing a value. Next time sequence will generate next value.
hope this helps
abhivyakti