What Can I use to hold multiple columns and rows?

Question

Aside from cursor what function can I use to hold multiple columns and rows?

Here is my sample query

With a as (
     select statement
    ), as b (
     select statement
    )

I want to put this in one variable or anything that can hold the return columns/rows

select a.column1 , b.column2, b.column2 
from a , b

`I want to put this one variable or anything I can us to hold this` ... can you explain better what this means? — Tim Biegeleisen, Apr 18 '17 at 01:24
*I want to put it in one variable or anything that can hold the return columns/rows — Potatooo, Apr 18 '17 at 01:29
View is does not physically exist, Cursor might work but I'm getting ORA-00928 — Potatooo, Apr 18 '17 at 01:59
Can we see the code that returns ORA-00928? Apart from the cursor, you can also try a nested table. — kpater87, Apr 18 '17 at 05:18

score 0 · Answer 1 · edited May 23 '17 at 12:09

0

It sounds like what you want is ... a table!? But assuming that's problematic, you could use a table variable or temp table. See: Does Oracle have an equivalent of SQL Server's table variables?

edited May 23 '17 at 12:09

Community

answered Apr 18 '17 at 06:28

Steve Lovell

1 Answers1