CASE beautifier

[TomOzi]

how can i set up a case beautifier?

i have this:

/*for plsql*/
  CASE
    WHEN pTYPE = 1 THEN
      res := 1;
    ELSE
      res := 0;
  END CASE;

/*for sql*/
SELECT (CASE
         WHEN &d = 0 THEN
          'zero'
         ELSE
          'no zero'
       END) as date_begin
  FROM dual;

I want to get in one line

CASE
 WHEN pTYPE = 1 THEN res := 1;
 ELSE res := 0;
END CASE;

/*for sql*/
SELECT (CASE
         WHEN &d = 0 THEN 'zero'
         ELSE 'no zero'
        END) as date_begin
  FROM dual;

Thanks

 

[Marco Kalter]

There is currently no option for this. I have added this to the list of enhancement requests.