Temp table question

With SQL Sever I've created temp table structures in memory but am not sure how to do this with Oracle 8.0.5. Is refcursor the closest thing there is? Thank you

--
To reply directly, replace the zero in my email address with the letter e.