SEQUENCE 1
[Oracle/SQL] ์‹œํ€€์Šค (Sequence)

0. ์‹œํ€€์Šค๋ž€? - ์ž๋™์œผ๋กœ ์ˆœ์ฐจ์ ์œผ๋กœ ์ฆ๊ฐ€ํ•˜๋Š” ์ˆœ๋ฒˆ์„ ๋ฐ˜ํ™˜ํ•˜๋Š” ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ๊ฐ์ฒด. - ๋ณดํ†ต PK๊ฐ’์—์„œ ์ค‘๋ณต๋ฐœ์ƒ ๋ฐฉ์ง€๋ฅผ ์œ„ํ•˜์—ฌ ์‚ฌ์šฉ 1. ๊ฐœ๊ด„ 1) ์ƒ์„ฑ CREATE SEQUENCE ์‹œํ€€์Šค๋ช…-- ์‹œํ€€์Šค๋ช…: table๋ช…_์ปฌ๋Ÿผ๋ช…_seq START WITH 1-- 1๋ถ€ํ„ฐ ์‹œ์ž‘ INCREMENT BY 1-- 1์”ฉ ์ฆ๊ฐ€ NOCACHE-- ์บ์‹œ ์‚ฌ์šฉX NOCYCLE;-- NOCYCLE ์„ค์ •์‹œ ์ตœ๋Œ€๊ฐ’ ์ƒ์„ฑ ์‹œ ์‹œํ€€์Šค ์ƒ์„ฑ์„ ์ค‘์ง€ํ•œ๋‹ค. - start with, increment by, nocache, nocycle์ด ๋ฌด์—‡์ธ์ง€ ๊ถ๊ธˆํ•˜๋‹ค๋ฉด ์•„๋ž˜์˜ '2. ์˜ต์…˜' ์ฐธ๊ณ  2) ์‚ญ์ œ DROP SEQUENCE ์‹œํ€€์Šค๋ช…; 3) ์กฐํšŒ - ์ „์ฒด ์‹œํ€€์Šค ์กฐํšŒ - ๋งŒ๋“ค์–ด์ ธ ์žˆ๋Š” ๋ชจ๋“  ์‹œํ€€์Šค๋ฅผ ์กฐํšŒํ•œ๋‹ค. SELECT * FROM USER_S..
Programming/Database(Oracle, SQL) 2020.02.16
1
๋”๋ณด๊ธฐ
๋ฐ˜์‘ํ˜•

ํ‹ฐ์Šคํ† ๋ฆฌํˆด๋ฐ”