Scripts, Articles, Relevant for DBAs, Consultants, BI, Data Scientists and Developers
SELECT *, ARRAY_CONSTRUCT( * ) combined FROM "AP_PROD"."ORACLEOACS_SIEBEL"."WC_PRODUCT_D" PROD_ORACLE where ARRAY_CONTAINS( 'CIFDA-90'::variant, combined );