Shell Programming and Scripting

DROP TABLE
     "FACT_WORLD";
 
CREATE TABLE "FACT_WORLD" (
              "AR_ID" INTEGER NOT NULL,
              "ORG_ID" INTEGER NOT NULL
              )
      DATA CAPTURE NONE
      COMPRESS YES;

DROP TABLE "FACT_WORLD";
 
CREATE TABLE "FACT_WORLD" ("AR_ID" INTEGER NOT NULL, "ORG_ID" INTEGER NOT NULL) DATA CAPTURE NONE COMPRESS YES;

 tr '\n' ' ' < filename | sed -e 's/;/;\n/g' -e 's/[[:blank:]][[:blank:]]*/ /g'

sed -n 'H;$g;s/\n//g;s/;/;\n/g;s/  */ /g;$p' file

 awk 'BEGIN{RS=";"; ORS=";\n"}$1=$1'  yourSQL.sql

kent$ cat t.txt
aaa
bbb;
ccc
ddd;
eee
fff;

print the line directly:
kent$ awk 'BEGIN{RS=";";ORS=";\n"}{print $0}' t.txt
aaa
bbb;

ccc
ddd;

eee
fff;

;

$1 was reset, output lines look good, but the empty line is still there
kent$ awk 'BEGIN{RS=";";ORS=";\n"}{$1=$1;print $0}' t.txt
aaa bbb;
ccc ddd;
eee fff;
;

ok, now the empty line was filtered out with if statement
kent$ awk 'BEGIN{RS=";";ORS=";\n"}{if($1=$1) print $0}' t.txt
aaa bbb;
ccc ddd;
eee fff;

so if write it in short:
kent$ awk 'BEGIN{RS=";";ORS=";\n"}$1=$1' t.txt               
aaa bbb;
ccc ddd;
eee fff;

($1=$1)