Handling of Sequences in Oracle

In Oracle, as per my current understanding- which could be incomplete, is that suppose I have table Employee(EmpId, Name) where I want EmpId as a sequence then how I would do it is-

CREATE TABLE Employee(EmpId int, name varchar(50)); CREATE SEQUQNCE EmpSeq;
insert into employee values(EmpSeq.nextval, 'Manoj');

So the application explicitly needs to get a nextval and insert it into the table.

How its handled in SQL Server isCREATE
 TABLE Employee(EmpId int IDENTITY, name varchar(50)); insert into employee(name) values('Manoj');

In this insert the sequencse field EmpId will automatically get populated with sequencial numbers. So no coding needs to be done for handling sequences.

Question- Is there any way in which I can get the SQL Server type sequence behaviour (i.e. I don't explicitly need to handle sequences and its done automatically) in Oracle?

Thanks for your time,
- Manoj Received on Mon Jul 09 2001 - 10:39:55 CEST