오라클 Day 8

📝 목차

Chapter 13 객체 종류

---

Chapter 13 객체 종류

📌 문제 1

-- 문제 1
CREATE TABLE EMPIDX
AS SELECT * FROM EMP;

-- 문제 2
CREATE INDEX IDX_EMPIDX_EMPNO ON EMPIDX(EMPNO);
	     
-- 문제 3
SELECT * FROM USER_INDEXES 
WHERE INDEX_NAME = 'IDX_EMPIDX_EMPNO';

📌 문제 2

CREATE OR REPLACE VIEW EMPIDX_OVER15K 
AS (SELECT EMPNO, ENAME, JOB, DEPTNO, SAL, NVL2(COMM, 'O', 'X') AS COMM 
	FROM EMPIDX 
	WHERE SAL > 1500); 

📌 문제 3

-- 문제 1
CREATE TABLE DEPTSEQ
AS SELECT * FROM DEPT; 
	
-- 문제 2
CREATE SEQUENCE SEQ_DEPTSEQ 
	START WITH 1
	INCREMENT BY 1
	MAXVALUE 99
	MINVALUE 1
	NOCYCLE NOCACHE;
   
-- 문제 3
INSERT INTO DEPTSEQ(DEPTNO, DNAME, LOC) 
VALUES(SEQ_DEPTSEQ.NEXTVAL, 'DATABASE', 'SEOUL');

INSERT INTO DEPTSEQ(DEPTNO, DNAME, LOC) 
VALUES(SEQ_DEPTSEQ.NEXTVAL, 'WEB', 'BUSAN');

INSERT INTO DEPTSEQ(DEPTNO, DNAME, LOC) 
VALUES(SEQ_DEPTSEQ.NEXTVAL, 'MOBILE', 'ILSAN');

Reference

• Do it 오라클로 배우는 데이터베이스 입문