$ sqlplus scott/tiger@localhost/oimrep

SQL*Plus: Release 11.2.0.4.0 Production on Wed Feb 19 22:06:08 2020

Copyright (c) 1982, 2013, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>  create table dropme22 ( id number, name varchar2(30));

Table created.

SQL> drop table dropme22;

Table dropped.

SQL> 

with tbl(col1,col2,col3) as (
select 1,'name1',to_date('11.02.1921','DD.MM.YYYY') from dual union all
select 2,'name2',to_date('11.02.1922','DD.MM.YYYY') from dual union all
select 3,'name3',to_date('11.02.1923','DD.MM.YYYY') from dual 
)
select col2 from tbl...