Oracle 18c

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

create table table1 (col1, col2) as
  SELECT 1, 2 from dual union all
  SELECT 3, 4 from dual union all
  SELECT 5, 6 from dual union all
  SELECT 7, 8 from dual union all
  SELECT 9, 0 from dual
5 rows affected

create table table2  as
  ( SELECT COL1, COl2 FROM TABLE1 ORDER BY COL1 )
ORA-00907: missing right parenthesis

create table table3 as
  SELECT COL1, COl2 FROM TABLE1 ORDER BY COL1
5 rows affected

create table table4 as
  (SELECT COL1, COl2 FROM TABLE1)
5 rows affected

create table table5 as
  SELECT COL1, COl2 FROM TABLE1
5 rows affected

SELECT COL1, COL2
  FROM (SELECT *
          FROM TABLE1
          ORDER BY COL2)


COL1
COL2


9
0

1
2

3
4

5
6

7
8


SELECT COL1, COL2
  FROM (SELECT *
          FROM TABLE1)
  ORDER BY COL2


COL1
COL2


9
0

1
2

3
4

5
6

7
8