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
Posted by 농부지기
,