데이터베이스 20180822 (학원9) 실습2

문제!!!!

1. DML 실습 01

2. DML 실습 02

3. DML 실습 03

4. DML 실습 04

5. DML 실습 05

6. DML 실습 06

-------------------------------------------------------------------------------------------------------------------------------------------------------------

============================================================================================

============================================================================================

---

---

정답!!!

--1번 종규답

CREATE TABLE RUNNINGMAN(

NO NUMBER PRIMARY KEY,

ID VARCHAR2(20) UNIQUE,

PASS VARCHAR2(20) NOT NULL,

NAME VARCHAR2(20) NOT NULL,

NICKNAME VARCHAR2(20) UNIQUE,

GENDER CHAR(1),

TEL VARCHAR2(20) default '010-0000-0000' ,

ADDRESS VARCHAR2(90)

);

--2번 종규답

INSERT INTo RUNNINGMAN VALUES(1,'muhan','1234','유재석','못생긴형','M','010-4958-2333','압구정');

INSERT INTo RUNNINGMAN VALUES(2,'bignose','4444','지석진','지는해','M',default,'서울');

INSERT INTo RUNNINGMAN VALUES(3,'tiger','6658','김종국','안꼬','M','010-6674-8986','안양');

INSERT INTo RUNNINGMAN VALUES(4,'haha','5356','하하','신분세탁','M','010-8997-1122','서래마을');

INSERT INTo RUNNINGMAN VALUES(5,'ace','5555','송지효','천성임','F',default,'서울시');

INSERT INTo RUNNINGMAN VALUES(6,'girrafe','6658','이광수','중기친구','M','010-2378-9991','남양주');

INSERT INTo RUNNINGMAN VALUES(7,'ssapssap','5356','양세찬','김종국팬','M','010-1215-7777','동두천');

INSERT INTo RUNNINGMAN VALUES(8,'doli','5555','전소민','전두릅','F',default,'일산');

select * from runningman;

--3번 종규답

update RUNNINGMAN set pass=9999 where nickname='중기친구';

select * from runningman;

--4번 종규답

UPDATE RUNNINGMAN SET TEL='없음' where tel='010-0000-0000';

select * from runningman;

--5번 종규답

DELETE FROM RUNNINGMAN WHERE NAME='유재석';

select * from runningman;

--6번 종규답

TRUNCATE TABLE runningman;

select * from runningman;