[언어] Oracle 기본 문법 정리

SQL 기본 문법

DDL

• CREATE, ALTER, DROP, RENAME, TRUNCATE

DML

• SELECT, INSERT, UPDATE, DELETE

DCL

• GRANT, REVOKE

  TCL

• COMMIT, ROLLBACK, SAVEPOINT

나를 위한 오라클 기본 문법 정리

SELECT FROM WHERE NVL, NVL2 CASE, DECODE GROUP BY HAVING INSERT UPDATE DELETE CREATE ALTER RENAME TRUNCATE DROP VIEW PROCEDURE FUNCION WITH

• PARTITION BY

class