Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 0 down vote favorite

In Sql server, My Procedure will create temporary tables where column names are dynamically comes from every user, then inserts the data into the temporary tables and 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 sql logic code to Oracle Database. Is their any solution to achieve this requirement in Oracle Database Server.

Answers are greatly appreciated.

share|improve this question
Not really, you'll need to rethink your logic for anything that used to create tables on the fly. Since you don't explain exactly what needs to be done, we can't really help you. – Mat May 2 at 5:40

migrated from stackoverflow.com May 2 at 11:43

1 Answer

up vote 1 down vote

Global temporary tables in Oracle are very different, as they have a permanent logical definition and transient storage, so practically the reverse of your situation.

I would look at trying to avoid temporary tables at all, in favour of Common Table Expressions (WITH clauses). They are very powerful stuff and can transiently use temporary disk space if it aids performance.

Otherwise you'll have to manually code unique table names etc -- it'll be unpleasant to support in future.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.