Re: niceSQL / SQL Formatter

ingehalv <member45830_at_dbforums.com> wrote in message news:<3561692.1068030260_at_dbforums.com>...
> The tool is approved by downloads.com and eSellerate.
>
> Its a C# based Nice-To-Have tool that works.
>
>
>
> See: http://download.com.com/3000-2210-10238125.html?tag=lst-0-1
>
>
>
> See: http://home.broadpark.no/~ihalvor/

Here is useful SQL formatter (in bcsh).
I quickly wrote this coz I don't wanna install heavy prog on my system. This is not so good, but not that bad.

  while read line;
  do
    for word in $line
    do

      u_word=`echo $word | tr [:lower:] [:upper:]`
      if [ $u_word = "SELECT" ] || \
         [ $u_word = "WHERE" ] || \
         [ $u_word = "FROM" ] || \
         [ $u_word = "ORDER" ] || \
         [ $u_word = "DECLARE" ] || \
         [ $u_word = "BEGIN" ] || \
         [ $u_word = "EXCEPTION" ]
      then
        echo $word
      else
        echo '       '$word 
      fi
 

    done
  done < $INPUT_FILE