查询索引是否命中

SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY);

EXPLAIN PLAN FOR
select  distinct ACCOUNT_CODE, ACCOUNT_NAME
from v_mft_sss

从json字段取json的某个字段值

select JSON_VALUE(OUTPUT_EXT, '$.ASSET_RIGHT_AMOUNT_REVERSAL_DQ'))
from dual