UNION SELECT INDUSTRY_SEQ.NEXTVAL UNION SELECT INDUSTRY_SEQ.NEXTVAL UNION SELECT INDUSTRY_SEQ.NEXTVALUNION SELECT INDUSTRY_SEQ.NEXTVAL UNION SELECT INDUSTRY_SEQ.NEXTVAL UNION SELECT INDUSTRY_SEQ.NEXTVALUNION SELECT INDUSTRY_SEQ.NEXTVAL U
我创建了一个按下降顺序按表顺序由其他列引入的序列。CREATE SEQUENCE seq_athlete_id START WITH 1001 OWNED BY tb_athlete.id;CREATE TABLE olympic.tb_athlete ( athlete_id CHARACTER(7) NOT NULL,
name CHARACTER VARYING(50) NOT N