SQL & PL/SQL

On sql server database, we often use temp table to keep some temp data. How can we do these on oracle database? For example:

on sql server:

create procedure proc(@p char(40)) as
begin
insert #temptablle
select pkid from sometable
end

In another procedure, we might call this procedure, and make further to query this temp table to do something. How can we do this on oracle?

Thanks

Edited by: user778708 on 2009-6-11 上午8:20