@AndrewSouthpaw

I guess it would have to be changed because if there is some other column that gets added to the table, then we would have to update the query and select the newly added column as well.

If we use select ALL(select * ) we won't have to edit the query, as it selects all the columns there are to select.

I really love this solution.

You could just use products.*

Glad my solution took me hours to write, and is 35 lines. (-_-) To be fair to myself, I was hellbent on preserving the data type and not converting the input to a string. Why? Not sure exactly. But I did it.

Good way to create a PL/SQL function using sql

so why do we have to specify that we're using SQL ?

How come so many people have given this specific answer?

Can you explain your reasoning there? Why should the query have to be edited if the table's column set changes?

I'm sorry, I don't understand. What do you mean by "reply then"?