You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

sql functions

Question
1
Views
0
Comments
in Reporting & Analytics for Fusion Service

Looking for sql function to use inside BIP report which does the following:


We have a table column that stores: -AE,BH,BR,CA,CH,CN,GB,HK,IE,KW,MX,NL,OM,QA,SA,SG,US

we would need to retrieve this as: -AE,-BH,-BR,-CA,-CH,-CN,-GB,-HK,-IE,-KW,-MX,-NL,-OM,-QA,-SA,-SG,-US

any idea how to achieve this?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!