- 17.9K All Categories
- 3.4K Industry Applications
- 3.4K Intelligent Advisor
- 73 Insurance
- 537.3K On-Premises Infrastructure
- 138.6K Analytics Software
- 38.6K Application Development Software
- 6K Cloud Platform
- 109.6K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.2K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
Listagg separator is not working when used in OEM, same has been working on SQl prompt
Hi All, i've used 'listagg(output, chr(10)) within group ( order by output) as LOG' it is working on sql prompt but not working when i've used this in OEM metric.
FYI, the requirement here is to send the log column as an email alert from OEM.
can anyone please help me here ? I've tried multiple options but none of them seems to be working.
The data is being interpreted in http format in mail sent by OEM.
Thanks in advance.