Auto increment in sql oracle - ( Auto increment field )
auto increment in sql oracle
-----------------------------------------------
CREATE table customers
( customer_id int not null,
customer_name varchar(50),
primary key (customer_id)
);
create sequence customer_id minvalue 1 start with 1 cache 10;
insert into customers values(customer_id.nextval,'maxwel');
-- to drop sequence
drop sequence customer_id