2

SQL> with cte_test 2 as 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 ...


1

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: ./...


Only top voted, non community-wiki answers of a minimum length are eligible