[DB] ORACLE 정규식

 - 대괄호 안의 문자만 치환

COLUMN_VALUE = {"json_data":{"title":"subject","date":"20160718","category":"soccer","contents":"funny soccer","pix_list":[{"pix_num":"0","url":"http://pix.com/pix_0"}, {"pix_num":"1","url":"http://pix.com/pix_1"}, {"pix_num":"2","url":"http://pix.com/pix_2"}]}}

업데이트

UPDATE TABLE

SET COLUMN_VALUE = REGEXP_REPLACE(COLUMN_VALUE, '\[(.*?)\]', '[]');

-> COLUMN_VALUE = {"json_data":{"title":"subject","date":"20160718","category":"soccer","contents":"funny soccer","pix_list":[]}}