Oracle创建序列从10000000开始的SQL语句
To create a sequence in Oracle starting from 10000000, you can use the following SQL statement: \n\nsql\nCREATE SEQUENCE EMR.SEQ_CONSULTATION\n START WITH 10000000\n INCREMENT BY 1\n NOCACHE\n NOCYCLE;\n\n\nThis statement creates a sequence named "SEQ_CONSULTATION" in the schema "EMR". The sequence starts with 10000000 and increments by 1 for each generated value. The "NOCACHE" option means that the sequence will not be preallocated in memory, and the "NOCYCLE" option means that the sequence will not cycle back to the start value after reaching the maximum value.
原文地址: https://www.cveoy.top/t/topic/qeny 著作权归作者所有。请勿转载和采集!