Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Pivot column into row

848002Jul 16 2014 — edited Jul 16 2014

Hello All,

Having an hard time trying to make a pivot in SQL.

E.G. :

labelvalue_textvalue_dateid
Po #345NULL112
Po #123456NULL120
Po #935131NULL134

So I would like to have the label section as a column name and put the value_text under the appropriate column but want to keep the ID in order to make a table with my view and join it to another table on a sql request.

Is that possible ?

Regards,

Eric

Comments

Timo Hahn

User, tell us your exact JDev version, please!
Your REST endpoint wouldn't make sense this way. The 'Employees' represent a collection that isn't parameterized by default. That's why you normally add something like 'action' or 'acton/test1' to the endpoint to make sure everybody knows that you do something on the collection of employees.
I would not encourage you to use the method at all, as in 12.2.1.4 you don't even get it in the wizard. It's easier to create your own REST service and call the application module methods from there. This way you can design your own API, e.g more like OpenAPI instead of relying on JDev and ADF.

Timo

Joby-Oracle

I am using Jdev 12.2.1.5.0.
I used the above link for reference.
My actual URL looks like:
{{hostAddress}}/restApp/resources/11.13.18.05/employees
I have added manually methodAction tag in the resource xml file , to enable the custom method.
So you are saying that this is not possible using ADF .

Timo Hahn
Answer

There is no official version 12.2.1.5. You are using an internal version not available to the public.
All I'm saying is that you don't even see the method tab in 12.2.1.4 and custom methods are depricated. So, yes, from my point of view you can't do it with ADF REST service.
It might be possible that you see the tab in your version, but then you have to ask this question to some internal resource.

Timo

Marked as Answer by Joby-Oracle · Jun 2 2022
1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 13 2014
Added on Jul 16 2014
#column, #pivot
4 comments
229 views