Hi All,
I have the date format in my DB as: '31-DEC-17'
and the timestamp for for the same is:
"31/12/2017
12:00:00"
I need the date in the following format say: Jan'17.
How can I achieve this?
Regards,
Dolly
To add to Joel's reply, the best way I find when you want something that is not out of the box is to use the nearest equivalent and then change the drop box to custom - the custom will then be populated with a starter for ten that you can subtly edit to get what you want, without starting from nothing...
totally agree with @Robert Angel. it's a tip that I also use...
Thanks Joel!
It worked for me.
Where AI meets business outcomes Oracle AI World brings the Oracle community together to explore how AI and other technology innovations are driving real business outcomes across industries. Discover what’s new through: Mainstage keynotes to hear the latest directly from Oracle leadership Product demonstrations Customer…
In BIP. I was able to group tables. Is this possible in OAC
I creates a parameter "Role Name" and then I put the Role name field in the filter and made a bind to the parameter, When I add the value in the parameter, it works. When I delete it from the parameter it give me <empty> How do I get rid of the <empty>
Hi Team, Has anyone upgrade OAS system from the 2024 to 2026 version? if yes, could you please share the resposne files. Regards, Chand
We need to download a report with the order number as the file name. In the main report, we have a data action (hyperlink) on each order number. When we click an order number, the linked report is downloaded with the corresponding order details. Currently, the file is downloaded using the report name. We need to download…
I tried the following expression and it blows up when I select more that one value in the list see image
