Sequence generation.

Hi!

        Thanks for reading this posting.
Can anybody explain me how to generate a sequence for a specific column. For example I want to an id column to be generated automatically in a sequence (1,2,3,4 i.e. something of sort of AUTOINCREMENT).

I tried to use a trigger for BEFORE INSERT, but was unsuccessful.

Can anybody help ?

Thanks & Regards

Abhimanyu Parasher

--