Beautifier question

[Drewb]

Is there a way to have the beautifier wrap the 'AND' in my where clauses to the next line, as in:

WHERE (AL1.CLAIM_NUM = AL2.CLAIM_NUM(+)
AND AL3.BILL_SEQ_NUM = AL1.BILL_SEQ_NUM

as opposed to what it currently does:

WHERE (AL1.CLAIM_NUM = AL2.CLAIM_NUM(+) AND AL3.BILL_SEQ_NUM = AL1.BILL_SEQ_NUM

In the general tab of the beautifier, I have the code formatted that way, but doesn't seem to affect how the beautifier does the formatting.

thx.

Drew

 

[ScottMattes]

Look on the DML tab instead.

 

[Drewb]

Is already that way on the DML tab:

SELECT depno AS department_number
,dname AS departmen_name
,loc AS department_location
FROM dept
,emp
WHERE emp.empno = p_empno
AND dept.deptno = emp.deptno;

 

[davemans]

Could it be because the 'AND' is inside brackets?
What happens if you remove them?

 

[Drewb]

Sorry, but I'm not seeing that the AND is in brackets.

Drew

 

[davemans]

In your code snippet

WHERE (AL1.CLAIM_NUM = AL2.CLAIM_NUM(+)
AND AL3.BILL_SEQ_NUM = AL1.BILL_SEQ_NUM

You have an opening quote after the WHERE but no matching closing quote. The beautifier will not parse correctly if their are syntax errors in the code.