In Sql server, my Procedure creates temporary tables where column names dynamically come from every user, then inserts data into temporary tables. I use the data further based on the requirement. Finally, we drop the temporary tables.
There is no problem when we create temporary tables with the same name and with different columns because in SQL Server the temporary tables are Session Based.
Now, I want to migrate the logic of the SQL Server code to Oracle. Is their any solution to achieve this requirement in Oracle Database Server.
Answers are greatly appreciated.