Category Archive: Shell Scripting

Sep 18

Formatting SQL in Oracle

I was looking for a way to format the output from EXPAND_SQL_TEXT and came across this post. I would really rather have something in the database that I could do this with. I would prefer not to spool anything out, but it works very well. Just another SQL beautifier

Sep 24

Unzipping all Zip files in a directory

I don’t know why zip can’t handle multiple inputs, but it cant’. Gzip does just fine unzipping everything in a directory, I use this little “script” all the time on the command line to unzip all the files in a directory. for file in $(ls *.zip) do echo $file unzip -o $file done Its a …

Continue reading »

Jul 03

Automating with Telnet

I have a stupid problem, I have a Bitcoin ASIC called a Hex miner. For some reason every 12 hours the thing slows down from 24GH/sec to 5GH/sec. The only way I have found to solve the problem is to power cycle the controller and the unit itself. This would be a pain since I …

Continue reading »