We have created a awesome themeFar far away,behind the word mountains, far from the countries
INFO ½ÇÀü DB¸ðµ¨¸µ°ú SQL°úÁ¤
¡á¿¹ 3_1_1 || Å×ÀÌºí »ý¼º ¿¹____CREATE TABLE____ CHAPTER_1( SABUN VARCHAR2(10) NOT NULL, NAME VARCHAR2(50) NOT NULL, AGE VARCHAR2(3), PHONE VARCHAR2(11), CONSTRAINT CHAPTER_1_PK PRIMARY KEY(SABUN))TABLESPACE SYSTEMPCTFREE 10PCTUSED 40INITRANS 1MAXTRANS 255STORAGE ( INITIAL 64 K NEXT 1024 K MINEXTENTS 1 MAXEXTENTS UNLIMITED FREELISTS 1 FREELIST GROUPS 1);
¡á¿¹ 3_1_2 || Å×ÀÌºí »ý¼º ¿¹ALTER TABLE CHAPTER_1 ADD(JOIN_DAY VARCHAR2(8)); --Ä÷³ Ãß°¡ALTER TABLE CHAPTER_1 COLUMN RENAME PHONE TO HP; --Ä÷³¸í ¼öÁ¤ALTER TABLE CHAPTER_1 MODIFY(AGE NUMBER(3)); --Ä÷³ DATATYPE º¯°æ
¡á¿¹ 3_1_3 || PRIMARY KEY Á¦¾àÁ¶°Ç ÁöÁ¤____CREATE TABLE____ CHAPTER_1( SABUN VARCHAR2(10) CONSTRAINT CHAPTER_1_PK_SABUN PRIMARY KEY);
¡á¿¹ 3_1_4 || NOT NULL Á¦¾àÁ¶°Ç ÁöÁ¤____CREATE TABLE____ CHAPTER_1( SABUN VARCHAR2(10) CONSTRAINT CHAPTER_1_PK_SABUN PRIMARY KEY NAME VARCHAR2(20) CONSTRAINT CHAPTER_1_nn_NAME NOT NULL);
¡á¿¹ 3_1_5 || NOT NULL Á¦¾àÁ¶°Ç ÁöÁ¤____CREATE TABLE____ CHAPTER_1( SABUN VARCHAR2(10) CONSTRAINT CHAPTER_1_PK_SABUN PRIMARY KEY NAME VARCHAR2(20) CONSTRAINT CHAPTER_1_nn_NAME NOT NULL PHONE VARCHAR2(11) CONSTRAINT CHAPTER_1_FK_PHONE FOREIGN KEY (PHONE) REFERENCES CHAPTER_2(PHONE) );
¡á¿¹ 3_1_6 || DEFAULT Á¦¾àÁ¶°Ç ÁöÁ¤____CREATE TABLE____ CHAPTER_1( SABUN VARCHAR2(10) CONSTRAINT CHAPTER_1_PK_SABUN PRIMARY KEY NAME VARCHAR2(20) CONSTRAINT CHAPTER_1_nn_NAME NOT NULL PHONE VARCHAR2(11) CONSTRAINT CHAPTER_1_FK_PHONE FOREIGN KEY (PHONE) REFERENCES CHAPTER_2(PHONE) PUT_START_DAY DATE DEFAULT SYSDATE );
¡áSQL 3_1_1 Å×À̺í Á¦¾à Á¶°Ç È®ÀÎSELECT A.TABLE_NAME, B.COLUMN_NAME, A.CONSTRAINT_NAME, A.CONSTRAINT_TYPE, A.SEARCH_CONDITIONFROM USER_CONSTRAINTS A, USER_CONS_COLUMNS BWHERE A.CONSTRAINT_NAME = B.CONSTRAINT_NAMEAND A.TABLE_NAME = 'INSA'AND A.CONSTRAINT_TYPE = 'P';
¡á¿¹ 3_1_7 || Á¦¾àÁ¶°Ç Ãß°¡ALTER TABLE INSAADD CONSTRAINT INSA_MOBILE_UK UNIQUE (MOBILE);
¡á¿¹ 3_1_8 || Á¦¾àÁ¶°Ç »èÁ¦ALTER TABLE INSADROP CONSTRAINT INSA_MOBILE_UK;