-- ■■■Oracleユーザー「dicdic」が作成されていることが前提■■■
-- dicdicで接続
CONNECT dicdic/Oracle11g

-- テーブルを削除
DROP TABLE JOINTEST_GENDER CASCADE CONSTRAINT PURGE;
DROP TABLE JOINTEST_NAME CASCADE CONSTRAINT PURGE;

-- テーブル「JOINTEST_GENDER」作成
CREATE TABLE JOINTEST_GENDER
  (GEND_CODE  NUMBER(1) CONSTRAINT PK_JOINTEST_GENDER PRIMARY KEY,
   GENDER    VARCHAR2(2) NOT NULL
  );

-- テーブル「JOINTEST_NAME」作成
CREATE TABLE JOINTEST_NAME
  (NAME_NO        NUMBER(1) CONSTRAINT PK_JOINTEST_NAME PRIMARY KEY,
   NAME            VARCHAR2(4) NOT NULL,
   GEND_CODE       NUMBER(1)
  );
                             
-- 各表にデータを投入
INSERT INTO JOINTEST_GENDER VALUES (1,'女');
INSERT INTO JOINTEST_GENDER VALUES (2,'男');
INSERT INTO JOINTEST_GENDER VALUES (3,'犬');
INSERT INTO JOINTEST_NAME VALUES(1,'Ａ郎',2);
INSERT INTO JOINTEST_NAME VALUES(2,'Ｂ郎',2);
INSERT INTO JOINTEST_NAME VALUES(3,'Ｃ郎',2);
INSERT INTO JOINTEST_NAME VALUES(4,'Ｄ郎',2);
INSERT INTO JOINTEST_NAME VALUES(5,'Ａ子',1);
INSERT INTO JOINTEST_NAME VALUES(6,'Ｂ子',1);
INSERT INTO JOINTEST_NAME VALUES(7,'Ｃ子',1);
INSERT INTO JOINTEST_NAME VALUES(8,'Ｄ子',1);
INSERT INTO JOINTEST_NAME VALUES(9,'Ａ釜',9);
commit;

-- dicdicを切断
disc
exit




















DROP TABLE JOINTEST_GENDER CASCADE CONSTRAINTS PURGE;
DROP TABLE JOINTEST_NAME CASCADE CONSTRAINTS PURGE;