Preserve Comments in SQL Query
I would like to follow up this post regarding preserving comments while editing a query in the QueryEditor. There it is stated that this will be implemented in the next major release. Is this still valid?
I would like to follow up this post regarding preserving comments while editing a query in the QueryEditor. There it is stated that this will be implemented in the next major release. Is this still valid?
Here is a simple SQL using hints for my comments and they "stick".
WITH c1 AS (SELECT /*+ -- CTE comments */ To_Char(:ENVIRO_NAME) AS ENVIRO_NAME,
To_Char(SYSDATE, 'YYYY-MM-DD') AS RUN_DATE
FROM DUAL)
SELECT /*+ -- MAIN comments */ c1.ENVIRO_NAME,
c1.RUN_DATE,
d0.CURR_DT
FROM (SELECT /*+ -- DERIVED comments */ SYSDATE AS CURR_DT
FROM c1) d0,
c1