I'm doing a little project and I need to do a plsql to return many rows.
I have someting like:
Table(id, data1, data2, from)
And the user gives me the value of from and I have to return all that.
The SQL is easy:
SELECT * FROM Table WHERE from = dataIntroduced
But, I don't know how the plsql can return that.
I read about collections but I think is not what I need
Best Answer
One way of return select data from PL/SQL is using Oracle table functions. Below is an example where the line
SELECT * FROM table_a where test_a = par1;
should be replaced by your select statement + change the table name.