Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE table_name (a, b, c, d, e, f) AS
SELECT 1, 2, 3, 4, 5, 'something' FROM DUAL UNION ALL
SELECT 6, 7, 8, 9, 0, 'something' FROM DUAL;
2 rows affected

WITH sqfc1 (a, b, c, d, e) AS (
  SELECT a, b, c, d, e
  FROM   table_name
  WHERE  f = 'something'
),
sqfc2 (a, b, c, d, m) AS (
  SELECT a, b, c, d, 2 * e + d
  FROM   sqfc1
  WHERE  a > 0 OR b > 0
)
SELECT a, d, m, b + c AS n
FROM   sqfc2
WHERE  m > 3 AND d > 0;


A
D
M
N


1
4
14
5

6
9
9
15


WITH sqfc1 (a, b, c, d, e) AS (
  SELECT a, b, c, d, e
  FROM   table_name
  WHERE  f = 'something'
)
SELECT *
FROM   sqfc1


A
B
C
D
E


1
2
3
4
5

6
7
8
9
0


BEGIN
  FOR r IN (
    WITH sqfc1 (a, b, c, d, e) AS (
      SELECT a, b, c, d, e
      FROM   table_name
      WHERE  f = 'something'
    )
    SELECT *
    FROM   sqfc1
  ) LOOP
    DBMS_OUTPUT.PUT_LINE(r.a || ', ' || r.b || ', ' || r.c || ', ' || r.d || ', ' || r.e);
  END LOOP;
END;
/
1 rows affected

dbms_output:
1, 2, 3, 4, 5
6, 7, 8, 9, 0