1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28
|
-- SELECT avec insertion
--DROP SEQUENCE seq_essai;
CREATE SEQUENCE seq_essai;
--DROP TABLE tst_insert;
CREATE TABLE tst_insert (
a INTEGER,
b INTEGER,
c INTEGER,
d INTEGER,
e INTEGER );
COMMIT;
INSERT INTO tst_insert ( a, b, c, d, e )
SELECT GEN_ID(seq_essai, 0) a, NEXT VALUE FOR seq_essai b, GEN_ID(seq_essai, 0) c, NEXT VALUE FOR seq_essai d, GEN_ID(seq_essai, 0) e
FROM t1;
COMMIT;
-- SELECT simple
DROP SEQUENCE seq_essai;
CREATE SEQUENCE seq_essai;
SELECT GEN_ID(seq_essai, 0) a, NEXT VALUE FOR seq_essai b, GEN_ID(seq_essai, 0) c, NEXT VALUE FOR seq_essai d, GEN_ID(seq_essai, 0) e
FROM t1; |
Partager