SQLize Online / PHPize Online  /  SQLtest Online

DROP SEQUENCE A_S; CREATE SEQUENCE A_S; DROP SEQUENCE B_S; CREATE SEQUENCE B_S; DROP TABLE A_TEST; CREATE TABLE A_TEST ( ANO NUMBER DEFAULT A_S.NEXTVAL PRIMARY KEY, ANAME VARCHAR2(20)); DROP TABLE B_TEST; CREATE TABLE B_TEST ( BNO NUMBER DEFAULT B_S.NEXTVAL PRIMARY KEY, BNAME VARCHAR2(20), ANO NUMBER, CONSTRAINT B_FK FOREIGN KEY (ANO) REFERENCES A_TEST(ANO)); INSERT INTO A_TEST(ANAME) VALUES ('JOHN'); INSERT INTO B_TEST(BNAME, ANO) VALUES ('JACK', A_S.CURRVAL); INSERT INTO B_TEST(BNAME, ANO) VALUES ('RON', A_S.CURRVAL); INSERT INTO A_TEST(ANAME) VALUES ('RONA'); INSERT INTO B_TEST(BNAME, ANO) VALUES ('JANO', A_S.CURRVAL);