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?

I talk about that here

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