Question: Suppose I have the following query, which returns a filtered table:

```
select column1,column2,column3 from table1 where table1.column1 = 'dada'

```

Further, suppose I want to store the resulting values in a variable so that I can use the result later on.

I have read that I can store a single value like so:

```
declare:
   result varchar(20);
begin:
   select column1 into result from table1 where table1.column1 = 'dada';
end;

```

But what about multiple values? There doesn't seem to be a "TABLE" or "DICTIONARY" datatype.

Answer: 
Use a **view** instead.

From W3Schools:

> 
> In SQL, a view is a virtual table based on the result-set of an SQL
>  statement.
> 
> 
> 

Here's how you create one:

```
create view view1 as select column1,column2,column3 from table1 where
table1.column1 = 'dada'

```
```
create view tempTable as select column1,column2,... from table1 where
table1.column1 = 'dada'

```