PS Query & SQL

One of my favorite things to have in the expressions. Start your expression with an explanation of what you are attempting to do - a real time saver when you have multiple equations that look like the same thing. 

Comments in Expressions

One of my favorite things to have in the expressions. Start your expression with an explanation of what you are attempting to do - a real time saver when you have multiple equations that look like the same thing. 

Comments in Expressions

Strictly speaking, a block comment in SQL doesn't include the plus sign, e.g.   

select something/* my block comment */from somewhere ;

The plus sign comes in when passing a "hint" to the DBMS, when you think you have a better way to optimize the query than the automatic optimizer.  That's a whole other topic!  See Oracle's documentation "Influencing the Optimizer with Hints."

PS Query allows hints but not block comments.  Here's what happens when I try a block comment in an expression, without using the plus sign:

Fortunately, Oracle database ignores unrecognized hints, thus we can trick PS Query into treating a bad hint like a good comment.

Welcome to the world of workarounds!  :-D

One of my favorite things to have in the expressions. Start your expression with an explanation of what you are attempting to do - a real time saver when you have multiple equations that look like the same thing. 

Comments in Expressions