SQL

Indentation

Indent using

• Spaces

  ci0

  if ('this_is' == /an_example/) {
  ****of_beautifer();
  } else {
  ****var a = b ? (c % d) : e[f];
  }

• Tab

  ci1

  if ('this_is' == /an_example/) {
  --->of_beautifer();
  } else {
  --->var a = b ? (c % d) : e[f];
  }

Indent number

• Range : 0-100

  cn

  //indent_number2
  select
    id
  from
    a
  where
    a.id = 1
  
  //indent_number4
  select
      id
  from
      a
  where
      a.id = 1

Subquery

Endline on subquery

• Yes

  el

  select
    id
  from
    a
  where
    a.id =
    (
      select
        no
      from
        b
      where
        b.id = 2
    )

• No

  select
    id
  from
    a
  where
    a.id = (
      select
        no
      from
        b
      where
        b.id = 2)

Min subquery len

• Range : 0-9999

  ml

  //len0
  select
    id
  from
    a
  where
    a.id = (
      select
        no
      from
        b
      where
        b.id = 2)
  
  //len100
  select
    id
  from
    a
  where
    a.id = (select no from b where b.id = 2)