오라클 DML

SELECT <column_list>

  FROM <table_list>

 WHERE <predicate_list>

 ORDER BY <column_list> ;

INSERT INTO <table_name>

    <( column_list )>

VALUES

    <( value_list )> ;

    

INSERT INTO 테이블명(컬럼1, 컬럼2, 컬럼3, ...)

VALUES(데이터1, 데이터2, 데이터3, ...)

UPDATE 테이블명

SET 컬럼1 = '입력할 값',

       컬럼2 = '입력할 값'

WHERE 조건;

delete from 테이블명 where 조건;

MERGE INTO <table_list>

USING <table_view_subquery>

ON (condition)

WHEN MATCHED THEN 

UPDATE SET 

column = <expr>

WHERE <predicate_list>

WHEN NOT MATCHED THEN 

INSERT (column_list)

VALUES (<expr_list>)

WHERE <predicate_list> ;