Hi,
Could you please help me out that i used below query is not working in production environment but it's working fine in development environment.
UPDATE lf_miscellaneous
SET card_type = (SELECT card_value
FROM (SELECT rn, substr(sys_connect_by_path(card_value, ','), 2) card_value
FROM (SELECT card_value, rownum rn FROM (
SELECT DISTINCT card_value
FROM lf_cardtype_mapping t, lf_cardtype a
WHERE t.card_id = a.id
AND a.status = 'A'))
START WITH rn = 1
CONNECT BY PRIOR rn + 1 = rn
ORDER BY rn DESC)
WHERE rownum = 1)
local development environment database details as below
---------------------------------------------------------------------------------
Oracle Database 10g Release 10.2.0.5.0 - 64bit Production
PL/SQL Release 10.2.0.5.0 - Production
CORE 10.2.0.5.0 Production
TNS for Linux: Version 10.2.0.5.0 - Production
NLSRTL Version 10.2.0.5.0 - Production
Production environment database details as below
---------------------------------------------------------------------------------
Oracle Database 10g Release 10.2.0.4.0 - 64bit Production
PL/SQL Release 10.2.0.4.0 - Production
CORE 10.2.0.4.0 Production
TNS for Linux: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production