AnsweredAssumed Answered

How put code in the "WITH" clause

Question asked by jsnpereira on Apr 13, 2012
Latest reply on Apr 17, 2012 by Dave
Hi, people!

I´m wanted know How put SQL WITH clause in the SQL in enviroment Clarity. see example the code below. because unique with clause is working in was execute SQL.
WITH
THISDAY AS 
(SELECT SYSDATE TDAY FROM DUAL)
SELECT TDAY
FROM THISDAY
let me know about code the how to create in clarity.


Thank you.

Jeison Pereira

Outcomes