OCP 덤프 노트

MERGE
No.36
No.42
This task can be done using the MERGE command. Correct syntax for the MERGE command
is MERGE INTO table1 USING table2 on (join_condition) WHEN MATCHED UPDATE
SET col1 = value WHEN NOT MATCHED INSERT (column_list) values (column_values).

Sub-Query
No.43

No.54
함수 사용법
SUBSTR, INITCAP, TRIM,

No.57
view - WITH CHECK OPTION -> INSERT or UPDATE 가능

No.64 BETWEEN 사용법
"WHERE deptno BETWEEN 10 AND 30"

애매모
No.71
No.73

No.77 Naming Rule

No.80
Nonequijoin

No.86
Constraint 사용법

No.89
equijoin

No.99 Outer Join

No.103
reuse the variable without prompting -> &&`