Archives for: " 2007, week 40"
how to generate a sql script in 5 mins
While fiddling with my thesis on SNA, I stumbled upon sql2dot.
I liked the idea,so I decided to give it a try and spooled off the db from oracle.
Then I did a
awk -F';' '{print "("$1","$2","$3", "$4");"}' spool.txt > filename, to prepare the sql… more »