Auto increment in sql oracle - ( Auto increment field )

preview_player
Показать описание
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;

-- to drop sequence
drop sequence customer_id
Рекомендации по теме
Комментарии
Автор

Only video providing auto increment in one liner command
🙌

anupamhaldkar
Автор

Really yaar, this video was very helpful. Thanks

itspraveenkp
Автор

Thanks for this video, It is helpful.

dhandapanisudhakar
Автор

How to handle error - name is already used by an existing object?

hohocham-ed
Автор

How do i insert this to another table? because the auto increment field like the customer ID is a foreign key for another table

pehkimwei
Автор

this code work even if i use a foreign key? sorry, for my english :(

karenortiz
Автор

What is the "cache 10" for?
I'm new to Oracle

rogeliodavidarce
Автор

Oracle is a pain in the ass, outdated methods... I'm just using it cuz they use this shit at work.

carvalho
Автор

that's code don't work with 11g !!

sirajalshami