I want to create a table where I have used With clause but keep getting an error.
First of all - is it possible and if so then how.
For the sake of simplicity see below as my actual sql is long.
WITH T1 AS
( SELECT 'TEST' AS AA, 25 AS NUM FROM DUAL)
CREATE TABLE TEST_ AS
SELECT AA, NUM FROM T1