dto1 Day22_Banking 예제 2 2023.09.12 DB TABLES * user : ICIA /* ACCOUNT A CLIENT B ACODE C */ -- 먼저 초기화 진행 DROP TABLE ACCOUNT; DROP TABLE ACODE; DROP TABLE CLIENT; CREATE TABLE CLIENT( CNUM NUMBER UNIQUE, CID NVARCHAR2(50) PRIMARY KEY, CPW NVARCHAR2(50), CNAME NVARCHAR2(50), CPHONE NVARCHAR2(50), CADDR NVARCHAR2(50) ); CREATE TABLE ACODE( CODENUM NUMBER PRIMARY KEY, CODENAME NVARCHAR2(10) ); INSERT INTO ACODE VALUES(1, '.. 2023. 9. 12. 이전 1 다음