By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table animals as select 'dog' as type from dual
1 rows affected
with
query1 as (
select * from animals where type = 'dog'
),
query2 as (
select a.*, type + 1 from animals a
)
select * from query1;
| TYPE |
|---|
| dog |
select a.*, type + 1 from animals a
ORA-01722: invalid number