SQL> with cte_test
3 (select * from emp);
(select * from emp)
ERROR at line 3:
ORA-00928: missing SELECT keyword
SQL> select cte_test as (select * from emp)
2 select * from cte;
select cte_test as (select * from emp)
ERROR at line 1:
ORA-00923: FROM ...
This is only a matter of the metadata being incomplete in the installer.
If you have access to Oracle support, then:
Reference data is not available for release "12.1" on Linux x86-64 SLES-12 (Doc ID 2127760.1)
In the above note, there is a link for the patch for this issue.
The workaround is to ignore the prerequisites by starting the installer as: