Skip to content
Advertisement

Select a column from table return by function in Oracle

I have a function that returns a table of custom objects. I wish to select a certain column by name from the returned result.

The table of objects

The function

When I call the function this way, I get a result with a single column called SERIAL_NUMBER

However, I can’t do something like this

Is there a way to select the column SERIAL_NUMBER ?

Advertisement

Answer

“I can’t” is difficult to debug. I’ll show you that I can (on the same database version you use).


Testing:

User contributions licensed under: CC BY-SA
7 People found this is helpful
Advertisement