Skip to content

Instantly share code, notes, and snippets.

@kimki1124

kimki1124/oracle_02.sql

Created March 7, 2017 12:46
Show Gist options
  • Save kimki1124/f3e79590e771e8c6301d8bdb9f60f2b6 to your computer and use it in GitHub Desktop.
Save kimki1124/f3e79590e771e8c6301d8bdb9f60f2b6 to your computer and use it in GitHub Desktop.
Download ZIP
[ORACLE] 테이블, 테이블 생성, 데이터 타입, 제약조건
Raw
oracle_02.sql
CREATE TABLE EMPLOYEES(
EMPLOYEE_ID NUMBER(6,0) NOT NULL,
EMP_NAME VARCHAR2(80) NOT NULL,
…
SALARY NUMBER(8,2),
HIRE_DATE DATE NOT NULL,
…
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment