We help IT Professionals succeed at work.

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

alsatham hussain
on
147 Views
Last Modified: 2017-03-20
Hi,

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.
Thanks
Alsatham hussain
Comment
Watch Question

PortletPaulEE Topic Advisor
CERTIFIED EXPERT
Most Valuable Expert 2014
Awarded 2013

Commented:
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.
CERTIFIED EXPERT
Most Valuable Expert 2012
Distinguished Expert 2019
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
alsatham hussainOracle developer

Author

Commented:
sorry for the delay

 Thank you so much for your advice and guidance

Thanks

ASH