Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Sequence in PL/SQL [closed]

How to create a sequence that gives value like 1, -1, 1, -1, 1, -1 ... ??

like image 922
Keyboard Avatar asked Dec 22 '25 16:12

Keyboard


1 Answers

create sequence darshan
    start with 1
    maxvalue 1
    minvalue -1
    increment by 2
    nocache 
    cycle;

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!