Opened 9 years ago

Closed 9 years ago

#27789 closed Cleanup/optimization (fixed)

Simplified get sequence value on Oracle.

Reported by: Mariusz Felisiak Owned by: Mariusz Felisiak
Component: Database layer (models, ORM) Version: dev
Severity: Normal Keywords:
Cc: Triage Stage: Ready for checkin
Has patch: no Needs documentation: no
Needs tests: no Patch needs improvement: no
Easy pickings: yes UI/UX: no

Description

I propose to use explicit 

seq_value := sequence.nextval;

instead of

SELECT sequence.nextval INTO seq_value FROM dual

It is valid since Oracle 11g.

Change History (2)

comment:1 by Tim Graham, 9 years ago

Triage Stage: Unreviewed → Ready for checkin

​PR

comment:2 by Tim Graham <timograham@…>, 9 years ago

Resolution: → fixed
Status: assigned → closed

In 89501d92:

Fixed #27789 -- Simplified query for sequence value on Oracle.

Note: See TracTickets for help on using tickets.
Back to Top