Oracle - DELETE 문
1. JOIN 후 DELETE
delete from TBt_SBATPAME aa
where aa.ech_code = ( select comm_tract_cd from tb_store_master b where aa.ech_code = b.comm_tract_cd
'(DB) Oracle > SQL' 카테고리의 다른 글
Oracle - 예제_MERGE (0) | 2017.01.18 |
---|---|
Oracle - 예제_INSERT (0) | 2017.01.18 |
Oracle - ROWNUM 개념 (0) | 2017.01.18 |
Oracle - SUB QUERY 개념 (0) | 2017.01.18 |
Oracle - JOIN 개념 (0) | 2017.01.18 |