ORA9I学习笔记_判断两个字符串是否相同
SELECT aos_pbx_index_flag FROM
(
(SELECT 'SAME' AS aos_pbx_index_flag FROM dual WHERE '@new_product_no[]'='@new_pbx_index[]')
UNION
(SELECT 'DIFF' AS aos_pbx_index_flag FROM dual WHERE '@new_product_no[]'!='@new_pbx_index[]')
)
(
(SELECT 'SAME' AS aos_pbx_index_flag FROM dual WHERE '@new_product_no[]'='@new_pbx_index[]')
UNION
(SELECT 'DIFF' AS aos_pbx_index_flag FROM dual WHERE '@new_product_no[]'!='@new_pbx_index[]')
)