Register to the Data Intelligence Summit London Register today to the Oracle Analytics Data Intelligence Summit in London on March 19th
Oracle Analytics was named as a Leader Oracle Analytics was named as a Leader in the 2024 Gartner® Magic Quadrant for Analytics and BI Platforms
New Oracle Analytics Data Visualization Challenge Register today to the Oracle Analytics Data Visualization Challenge and showcase your Data Visuzalization chops
Oracle Analytics Product Satisfaction Survey Share your experience and satisfaction with Oracle Analytics Product with our Product Satisfaction Survey

Welcome to the Oracle Analytics Community

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Comments

Hi Nirmal, Below code would fetch you New location details from data cache column. You need to replcae the value which you want to fetch in below code. Let me know if any doubt. select regexp_replace(substr(Q.LocationId_New,instr(Q.LocationId_New,'<',1) +10,instr(Q.LocationId_New,'</')-11),'<|>|OldValue|</|/>|NewValue','')…

in Syntax to fetch pending transfer details from Data_cache column in hrc_txn_data Comment by User_OWH0W April 2020