sqlplus - SQL*Plus 1,3 nDistributed Multimedia Systems LAB...

Info iconThis preview shows pages 1–20. Sign up to view the full content.

View Full Document Right Arrow Icon
SQL*Plus 실습 기초데이터베이스 1,3반 김은삼 교수님 n Distributed Multimedia Systems LAB n 1
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
DDL - Data Definition Language n Distributed Multimedia Systems LAB n 2
Background image of page 2
테이블 생성 & 변경 n Distributed Multimedia Systems LAB n 3
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
데이터 타입 n Distributed Multimedia Systems LAB n 4
Background image of page 4
데이터 타입 예 n Distributed Multimedia Systems LAB n 5
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
데이터 타입 예 n Distributed Multimedia Systems LAB n 6
Background image of page 6
테이블 생성 & 변경 예
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
테이블 생성 & 변경 예 n 컬럼의 속성 변경 n alter table 테이블명 modify ( 속성 데이터타입 ); n 테이블 삭제 n drop table 테이블명 ; n 테이블명 변경 n rename 테이블명 to 새로운테이블명 ;
Background image of page 8
DML - Data Manipulation Language n Distributed Multimedia Systems LAB n 9
Background image of page 9

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
제약 조건 - constraints n Distributed Multimedia Systems LAB n 10
Background image of page 10
제약 조건 - constraints n Distributed Multimedia Systems LAB
Background image of page 11

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 12
Background image of page 13

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 14
Background image of page 15

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 16
Background image of page 17

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 18
Background image of page 19

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 20
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 20

sqlplus - SQL*Plus 1,3 nDistributed Multimedia Systems LAB...

This preview shows document pages 1 - 20. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online