1.oracle临时表与sql server不一样,这个你要先了解下。 2.select语句这样表达: select rownum as id, name, year from tb1 order by name,year
------1.建立 sequence CREATE SEQUENCE my_sequence INCREMENT BY 1 -- 每次加几个 START WITH 1 -- 从1开始计数 NOMAXVALUE -- 不设置最大值 NOCYCLE -- 一直累加,不循环 CACHE 10; ---------2、建立临时表 CREATE TABLE T AS SELECT MY_SEQUENCE.NEXTVAL AS ID, NAME, YEAR FROM TBL ORDER BY NAME, YEAR
2.select语句这样表达: select rownum as id, name, year from tb1 order by name,year
CREATE SEQUENCE my_sequence
INCREMENT BY 1 -- 每次加几个
START WITH 1 -- 从1开始计数
NOMAXVALUE -- 不设置最大值
NOCYCLE -- 一直累加,不循环
CACHE 10; ---------2、建立临时表
CREATE TABLE T AS
SELECT MY_SEQUENCE.NEXTVAL AS ID,
NAME,
YEAR
FROM TBL
ORDER BY NAME,
YEAR