I am using 19c.
I would like to create a stored procedure that stores data in a temporary table.
I wanted to send the output of a select statement into a temporary table. Then I want to massage the data in the temporary table. I am aware of global temporary table. I tried it but did not have enough rights to use it.
Other than global temporary table, what options do I have.