[DERBY-103] Global Oracle/Axion style sequence generator

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Component/s: SQL
• Assignee: Suran Jayathilaka
• Reporter: Bernd Ruehlicke
• Created: 16/Dec/04 20:36
• Updated: 05/Feb/10 18:50
• Resolved: 05/Feb/10 18:50

Description

The identity column generator is just not enought. It would just be wonderful if Derby had commands like

CREATE SEQUENCE mySeq;

values mySeq.nextval;
values mySeq.currval;

CREATE TABLE my_table (
id integer default mySeq.nextval,
value varchar(40)
)

DROP SEQUENCE mySeq;

Issue Links

• is related to: DERBY-712 Support for sequences