A function that can accept SQL statements and return the results in a table format

@Himasha Abeywickrama 

I am not sure I understand the question… Does the customer want to do reporting? Performing an SQL statement and getting back data is what a Quick Report does, or one can create an IAL or Lobby data source to return data.

If you mean an Oracle facility to take any string and execute it, I would wonder why that is desirable? SQL can already perform very advanced queries where you can return almost anything you can imagine, including hierarchical, pivoted, and list-aggregated data. Throw in some WITH statements, sub-selects, and API calls and there isn’t much you can’t do.

In PL/SQL code, you can write code that returns datasets via things like dynamic querying, ref cursors, and pipelining. Is that what they are referring to?

Joe Kaufman

Pivoting is the answer

Jari