SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
DROP SEQUENCE DEPT_S; CREATE SEQUENCE DEPT_S; SELECT * FROM USER_SEQUENCES WHERE SEQUENCE_NAME = 'DEPT_S'; DROP TABLE DEPT_TEST_S; CREATE TABLE DEPT_TEST_S ( DEPNO NUMBER PRIMARY KEY, DNAME VARCHAR2(100)); INSERT INTO DEPT_TEST_S VALUES (DEPT_S.NEXTVAL, 'SALES'); INSERT INTO DEPT_TEST_S VALUES (DEPT_S.NEXTVAL, 'IT'); INSERT INTO DEPT_TEST_S VALUES (DEPT_S.NEXTVAL, 'ECONOMY'); SELECT * FROM DEPT_TEST_S; SELECT DEPT_S.CURRVAL WOW FROM DUAL; SELECT DEPT_S.NEXTVAL WOW FROM DUAL;

Stuck with a problem? Got Error? Ask ChatGPT!

Copy Clear