Sort
=begin
NUBG_002_CTRL のINSERT をCTRL_ID 順にSORT
=end
filename = 'C:\cvswork\NUBG\Table\NUBG\DATA\NUBG_002_CTRL.SQL'
file = open(filename)
list=Array.new
i=0
sql=""
while text = file.gets do
if /INSERT INTO NUBG.NUBG_002_CTRL/ =~ text then
if sql != "" then
list.push(sql)
end
sql = ""
end
sql = sql + text
end
if sql != "" then
list.push(sql)
end
file.close
list.sort{|a,b|
/INSERT INTO NUBG.NUBG_002_CTRL values\('([0-9]+)'/ =~ a
a1 = $1.to_i
/INSERT INTO NUBG.NUBG_002_CTRL values\('([0-9]+)'/ =~ b
b1 = $1.to_i
a1 <=> b1
}.each{|c|
print c
}