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

Can't get Oracle SQL Developer to display specific values from object table

I’ve started learning SQL and playing with Oracle SQL Developer v22. For some reason I’m not able to retrieve value from an object table by using SELECT VALUE(A). It only gives my user ID.object_name as in the below screenshot. Any tips why?

SELECT VALUE(A) FROM table A;

If I use SELECT * FROM table; all is fine.
SELECT * FROM table A;

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

I’ve tried printing using dmbs_output, same problem.
Tried with other object tables, same behaviour.

>Solution :

Please share your table DDL and DML for a more accurate answer, but setting this preference should do what you’re looking for

‘Display Struct Value in Grid’

enter image description here

I talk about that here

Disclaimer: I work for Oracle and am the product manager for SQL Developer.

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