Oracle/SEQUENCE 썸네일형 리스트형 ORACLE SEQUENCE How to generate a unique number (SEQUENCE)? Oracle has solved a problem of assigning unique numbers (i.e.: studentID) without having to create a special table and handle update an concurrence it by using CREATE SEQUENCE: In SQL*PLUS create a sequence generator CREATE SEQUENCE sID INCREMENT BY 1 START WITH 100 ORDER; This will create a sequence that can be accessed by insert and update statements.. 더보기 이전 1 다음