Shell Programming and Scripting

for file in /xxx/sss/*
do
    filename=$( basename $file )
    sed -e '1,2d; $d; /^[:space:]*$/d; /selected\.$/d' ${file} | \
    sed -e '1s/^/INSERT INTO '${filename}' VALUES (/; $!s/$/,/; $s/$/);/'
done

INSERT into tab1 (AAAAAAA,
BBBBBBB,
CCCCCCC)

INSERT into tab1 (AAAAAAA,
BBBBBBB,
CCCCCCC) select 
AAAAAAA,
BBBBBBB,
CCCCCCC
from tab1;

COLNAME
------------
AAAAAA
BBBBBB
CCCCCC
DDDDDD
...
...

...
ZZZZZZ
26 recrod(s) selected.

awk 'BEGIN{str="select ";printf "INSERT into tab1(  "} NR>2{print $0,"," ;str=str $0","} END{print ")" str, " from tab1"}'

INSERT into tab1(  ------------------------- ,
AAAA,
BBBB.
CCCC.

....
oooooo

  15 record(s) selected. ,
 ,)select -------------------------,AAAA,BBBB,CCCC,........  15 record(s) selected.,,  from tab1

awk 'BEGIN{str="select ";printf "INSERT into tab1(  "} !/^$/ && !/^[0-9].*/&&NR>3{print $0,"," ;str=str $0","} END{print ")" str, " from tab1"}' infile

$
$
$ cat f9
COLNAME
------------
AAAAAA
BBBBBB
CCCCCC
DDDDDD
ZZZZZZ
5 record(s) selected.
$
$
$
$
$ perl -ne 'chomp; push @x, $_ if ($.>2 && !/^.*selected.*$/ && !/^\s*$/);
           END {print "INSERT into tab1 (\n",join ",\n", @x;
                print ") select\n",join(",\n", @x), "\nfrom tab1;\n";
           }' f9
INSERT into tab1 (
AAAAAA,
BBBBBB,
CCCCCC,
DDDDDD,
ZZZZZZ) select
AAAAAA,
BBBBBB,
CCCCCC,
DDDDDD,
ZZZZZZ
from tab1;
$
$
$