Home » SQL & PL/SQL » SQL & PL/SQL » Table Variables
Table Variables [message #356578] Fri, 31 October 2008 05:11 Go to next message
amarsden85
Messages: 2
Registered: October 2008
Junior Member
Hello,

Does anyone know how to use either Temporary Tables or Table Variables in PLSQL. I need to write a function that utilises several Table Variables. I know how to do it in SQL Server but not done it in oracle before.

Any help would be appreciated Smile

Thanks
Re: Table Variables [message #356579 is a reply to message #356578] Fri, 31 October 2008 05:16 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You don't use temporary tables in Oracle.

Regards
Michel
Re: Table Variables [message #356580 is a reply to message #356579] Fri, 31 October 2008 05:17 Go to previous messageGo to next message
amarsden85
Messages: 2
Registered: October 2008
Junior Member
Thanks for the reply Michel, can I use a table variable instead?
Re: Table Variables [message #356582 is a reply to message #356580] Fri, 31 October 2008 05:23 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What I mean is your code differently in Oracle than in SQL Server.
If you code in Oracle as you code in SQL Server you just get bad code for Oracle (the opposite is also true, I didn't mean one is better than the other one).

Regards
Michel
Previous Topic: Passing the Collection Type as argument in procedure for oracle 10g R2
Next Topic: dbms_job from a procedure
Goto Forum:
  


Current Time: Sat Dec 03 09:51:43 CST 2016

Total time taken to generate the page: 0.04108 seconds