Oracle 23c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table t (first_name varchar2(100), last_name varchar2(100), birthday date);
WITH TEMP AS (select first_name, last_name, birthday from t);
ORA-00928: SELECT keyword missing

insert into t (first_name, last_name, birthday)
   values('Jess', 'Smith', date '1999-01-01');
1 rows affected

select * from TEMP;
ORA-00942: table or view does not exist

CREATE VIEW temp AS select first_name, last_name, birthday from t;
insert into t (first_name, last_name, birthday)
   values('John', 'Miller', date '2000-01-01');
1 rows affected

select * from TEMP;


FIRST_NAME
LAST_NAME
BIRTHDAY


Jess
Smith
01-JAN-99

John
Miller
01-JAN-00