WITH temp AS (SELECT TO_CLOB ('A') COL FROM DUAL)
SELECT *
  FROM temp where COL like '%USA';

SQL> with temp as
  2  (
  3      select
  4          to_clob('A') col
  5      from
  6          "PUBLIC".dual
  7  )
  8  select
  9      t1.col
 10  from
 11      temp t1
 12  where
 13      t1.col like '%USA';

no rows selected

SQL> 

SQL> with temp as
  2  (
  3      select
  4          to_clob('A') col
  5      from
  6          "PUBLIC".dual
  7  )
  8  select
  9      t1.col
 10  from
 11      temp t1
 12  where
 13      t1.col like '%USA';

COL
-------
A

SQL>

SQL>  create table t AS (SELECT TO_CLOB ('A') COL FROM DUAL);

Table created.

SQL> SELECT * FROM t where COL like '%USA';
COL
---------------------------------------------------------------
A

1 row selected.