Join devRant
Do all the things like
++ or -- rants, post your own rants, comment on others' rants and build your customized dev avatar
Sign Up
Pipeless API
From the creators of devRant, Pipeless lets you power real-time personalized recommendations and activity feeds using a simple API
Learn More
Related Rants
Wanna get the next value of a sequence in Oracle? Oh just do :
SELECT sequence_name.NEXTVAL FROM DUAL
Wanna get the current value instead? Try this query :
SELECT last_number FROM all_sequences WHERE sequence_owner = '<sequence owner>' AND sequence_name = '<sequence_name>';
Yeah thanks Oracle...
undefined
sequence
oracle
sql