Active Query Builder support area

Preserve Comments in SQL Query

Avatar
  • updated
  • Completed

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?

Avatar
Kelly

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