With the introduction of Oracle compatibility in MariaDB Server 10.3, it’s now possible to use Oracle PL/SQL and Oracle sequences in an open source database — making it easier for DBAs and developers ...

SQL> create sequence seq; Sequence created. SQL> select seq.nextval from dual; NEXTVAL ----- 1 SQL> select seq.nextval from dual; NEXTVAL ----- 2 SQL> select seq.nextval from dual; NEXTVAL ----- 3 ...

I have the need to create a sequence that when nextval is requested, the current year is prefix to the number. I also need to figure out a way to restart the sequence when the next year starts, but ...

Oracle's namesake database management system has a data type called a CLOB, or Character Large OBject. Though the standard character data type, called CHAR, has a size limit of 2,000 characters, you ...