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;

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’

I talk about that here

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