RegExp - Separator Query
Hi Team,
--------------------------------------------------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
PL/SQL Release 11.2.0.4.0 - Production
CORE 11.2.0.4.0 Production
TNS for IBM/AIX RISC System/6000: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 - Production
--------------------------------------------------------------------------------------------------------------------------
I would require help on the below.
I am trying to get the exact values even if NULL string is passed i.e. without any special characters appearing in the Separator section.
Here v_seperator is - symbol.
BEGIN
SELECT attribute1,attribute2,attribute3,attribute5
INTO v_attribute1,v_attribute2,v_attribute3,v_seperator
FROM fnd_lookup_values_vl
WHERE lookup_type = 'XX_MS_VAL';
l_unique_ref_number := v_attribute1