Geek asks and answers

SQL developer cleans up embedded hints

I am using SQL Developer 3.1.07. I ran a query to Oracle with a built-in tooltip --+ hint, but SQL Developer seemed to strip the tooltip before sending it to the database. Multi-line prompts are /*+ hint */not divided. Is it possible to save inline hints / comments in SQL Developer?

+5
source share
1 answer

I think the solution to this problem is to always use multi-line comment syntax, even for one hint:

select /*+ ordered */
      ename 
from emp
where ....

, uni-line --+ (, , , , ). , : , , , V $SQL.SQL_TEXT.

+2

More articles:


All Articles