Search on all the table - columns:

22/02/2024 18:41

SELECT *, ARRAY_CONSTRUCT( * ) combined
FROM "AP_PROD"."ORACLEOACS_SIEBEL"."WC_PRODUCT_D" PROD_ORACLE where ARRAY_CONTAINS( 'CIFDA-90'::variant, combined );