-- DDL(Data Definition Language): テーブル定義
CREATE TABLE products (prod_id NUMBER PRIMARY KEY, prod_name VARCHAR2(100));
-- DML(Data Manipulation Language): データ操作
INSERT INTO products VALUES (1, 'オラクル入門書');
SELECT * FROM products WHERE prod_id = 1;
-- DCL(Data Control Language): 権限管理
GRANT SELECT ON products TO user1;