Programmer's Note

CREATE TABLE EMP( EMPNO NUMBER(4) NOT NULL, ENAME VARCHAR2(10), JOB VARCHAR2(9), MGR NUMBER(4), HIREDATE DATE, SAL NUMBER(7, 2), COMM NUMBER(7, 2), DEPTNO NUMBER(2) ); INSERT INTO EMP VALUES (7369, 'SMITH', 'CLERK', 7902, TO_DATE('17-12-1980', 'DD-MM-YYYY'), 800, NULL, 20); INSERT INTO EMP VALUES (7499, 'ALLEN', 'SALESMAN', 7698, TO_DATE('20-02-1981', 'DD-MM-YYYY'), 1600, 300, 30); INSERT INTO E..

DDL (Data Definition Language): 데이터 정의CREATEALTERDROPRENAMETRUNCATECOMMENT QUERY: 데이터 조회SELECT DML (Data Manipulation Language): 데이터 조작INSERTUPDATEDELETE TCL (Transaction Control Language): 트랜젝션 제어COMMITROLLBACKSAVEPOINT DCL (Data Control Language): 데이터 제어GRANTREVOKE

[입문]Oracle Database: Introduction to SQLIntroduction to Oracle Database 1Introduction to Oracle Database 2Retrieve Data using the SQL SELECT Statement 1Retrieve Data using the SQL SELECT Statement 2Learn to Restrict and Sort Data 1Learn to Restrict and Sort Data 2Usage of Single-Row Functions to Customize OutputInvoke Conversion Functions and Conditional Expressions 1Invoke Conversion Functions ..