Oracle newbie here...

Is there such a thing as a table variable in Oracle?

I'm coming from an MSSQL background where I could do something like this:


DECLARE @x table (i int, j int)
insert into @x
select 0, 10

The table is only going to be two columns wide but it'll have a hundred rows or so.

Unfortunately because of the way permissions are set up, my user cannot create tables or temp tables so I'm looking for another way out

Thanks