SQL & PL/SQL

Hey all,

My client has asked me to see if it's possible to move his SQL Queries into Oracle, and then move EVERYTHING off of MSSQL into this new oracle environment. The problem is, I wrote the entire MSSQL system, and i know nothing about Oracle.

Basically, I need some examples. I have been stumbling around Oracle for about a year now, so i'm 'somewhat' familiar with it.

Basically, i'm going to create a script/stored procedure that will first:
Create and define a temporary table that is used when the script/proc is called.
Then, thru cursors, i'm going to add a bunch of lines to it.
Finally, i'm going to Run a select statement against the temporary table we created.

Now, I can't create a table on the server, as the production environment will not allow it, so i need to be able to create this virtually inside the script, and then it automatically self destructs at the end of the script.

If anyone knows if this is possible, please post me a few links to examples, or just lay down the code to get the temprary table made.

We're using TOAD as the interface.

Thanks,

Dan