Follow

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use
Contact

Oracle APEX – display SQL table in a particular way

I am making a user profile page and the user (currently logged in) data is stored in USERS table.
I created a user profile page and I have been changing the type of the Region, but none of them are what I’m looking for.

I want to display the user information like this:

enter image description here

MEDevel.com: Open-source for Healthcare and Education

Collecting and validating open-source software for healthcare, education, enterprise, development, medical imaging, medical records, and digital pathology.

Visit Medevel

This user information is fetched from SQL table, so I tried all Reports but table view is not what I’m looking for.

Is there a way to achieve this?

>Solution :

With a region type of "Classic Report", there is a report template called "Value Attribute Pairs – column". Here is an example (query source select * from emp where ename = 'KING' ):

builder

output looks like this.

report

Needs a bit of massaging – if you want headers like in the sample you showed then maybe 3 different report regions but you get the point.

Add a comment

Leave a Reply

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use

Discover more from Dev solutions

Subscribe now to keep reading and get access to the full archive.

Continue reading