Avatar of alsatham hussain
alsatham hussain
Flag for India asked on

sql server store procedure contains temp tables need to convert oracle?


I am struggling with migrating the temp tables (SQL server) to oracle. Mostly, oracle don't consider to use temporary table inside the store procedure but in sql server, they are using temp tables for  small fetching record and also manipulate same.
How to overcome  this issue.  I am also searching some online articles about migrating temp table to oracle but they are not clearly explained for my expectations.
i got information like using inline view, WITH clause, ref cursor instead of temp table. I am totally confused.
Please suggest me,  in which case may use Inline view, WITH clause, ref cursor.
This may be helpful for improve my knowledge and also doing job well.

As always thank you for your valuable time in helping out the newbies.
Alsatham hussain
Oracle Database

Avatar of undefined
Last Comment
alsatham hussain

8/22/2022 - Mon

This broad question is IMPOSSIBLE to answer simply

Using WITH is probably the easiest to implement because in many cases you can simply mimic the creation of a temp table this way.

BUT having said that I often sense that T-SQL developers OVERUSE temp tables and quite often they are simply not needed in Oracle.
slightwv (䄆 Netminder)

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
alsatham hussain

sorry for the delay

 Thank you so much for your advice and guidance


This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.