3 回复 由 thatJeffSmith-Oracle 于 2018-11-1 下午12:35 最新回复

    How to define format of SQL sentence when I drag table name?

    Blue Bird
    Blue Bird 2018-11-1 上午11:06

      I would like to know where in SQL Dev 18.3 I can define how is formatted generated SQL statement when you drag a table from the left to the worksheet on the right side? For example if I drag table DEPT and select

      I got this:

       

      SELECT
  DEPTNO ,
  DNAME ,
  LOC
FROM
  DEPT ;

       

      I would like to format my sentence like:

       

      Select
  Deptno,
  Dname,
  Loc
From
  Dept;

       

      The most important would be to remove extra space before comma. I was looking in the settings under Tools > Preferences > Code Editor > Format > Advanced Format, but I cannot find any line related how comma should be positioned. Are this settings related to this operation at all?

      By the way I use this settings in Format one level higher and I don't want to change it:

      Is trere some detail explanation how to format your code using Custom Format one level lower?

       

      Thanks,

      BB