Oracle锦集

1:将数组转成datatable

SELECT COLUMN_VALUE FROM TABLE(CAST(UTIL.INTONUMBERTABLE(REPLACE(NVL(V_CATEGORY_ID,'-999'),',',','),',') AS PKNUMBERTABLE))

posted @ 2013-12-06 15:19  小锋神  阅读(207)  评论(0编辑  收藏  举报