DB 1일 (23.03.21)

• https://wikidocs.net/book/550

1. DB 개요

• DB (Database) : 의미 있는 정보를 가진 데이터 집합, 저장할 가치가 있는 데이터들
• DBMS (Database Management System) : DB를 관리하는 시스템 (오라클, MySQL 등등)

2. DB 실행하기

• 도커로 오라클을 실행하는 것이면, 오라클이 돌아가는지 보고 실행한다.

• 워크시트에 원하는 명령어를 적고 실행

  • select * from emp;
  • select * from emp where sal > 3000;
  • select * from emp where deptno = 20;
  • select empno, ename, sal from emp where ename = 'SMITH';
  • desc emp;
  • select * from emp where hiredate >= '1982/01/01';
  • select * from emp where sal >=1000 and job = 'MANAGER';
  • select * from emp where deptno != 10;
  • select * from emp where deptno <> 10;
  • select * from emp where not deptno = 10;
  • select * from emp where sal between 2000 and 3000;
  • select * from emp where sal not between 2000 and 3000;
  • select * from emp where hiredate between '1981/01/01' and '1981/12/31';
  • select * from emp where deptno = 10 or deptno = 20;
  • select * from emp where job = 'CLERK' or job = 'MANAGER';
  • select * from emp where comm in (300, 500, 1400);
  • select * from emp where comm not in (300, 500, 1400);