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