What make REF_ROWS and SELECT display differently? I would like SELECT results to be displayed in a nice list like for REF_ROWS. See the picture below.
The display you see for REF_ROWS() is because it provides a list of rows (i.e., the key column values of rows). I’m guessing your SELECT() returns something other than key column values. To get a display like that for your REF_ROWS() column, your SELECT() must produce a list of key column values.
This sounds very interesting!
Could elaborate more on “key column values” and if the SELECT must returns exclusively these?
If you want it to act like REF_ROWS() it must.