REF_ROWS versus SELECT display

Hi,
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.

Hi @Steve.

This sounds very interesting!
Could elaborate more on “key column values” and if the SELECT must returns exclusively these?

Thanks!

If you want it to act like REF_ROWS() it must.

1 Like