SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
DROP SEQUENCE A_S; CREATE SEQENCE 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_S ( BNO NUMBER DEFAULT B_S.NXTVAL PRIMARY KEY, BNAME VARCHAR2(20), ANO NUMBER, CONSTRAINT B_FK FOREIGN KEY ANO REFERENCES A_TEST(ANO);

Stuck with a problem? Got Error? Ask ChatGPT!

Copy Clear