Scripting

From Eddie’s blog I got a link to 3 posts on Regular Expressions on OTN written by CD. Wonderful stuff. Check out. Part 1 Part 2 Part 3 & Thanks CD…wonderful work buddy ! Comments Comment by Tyler on 2008-02-28 07:51:45 +0530 I’ve been working with regular expressions in PL/SQL a lot lately and the one tool that’s helped me more than any other is Regex Buddy (http://www.regexbuddy.com/). Yeah, it’s not free, but it was the best $40 I’ve spent. There are free options, like regex coach and a few free online options, but the problem is you have to find one that matches the Oracle specific Posix ERE format. Regex buddy even has a drop-down for Oracle syntax (http://www.regexbuddy.com/oracle.html). I have no affiliation with this tool whatsoever, just found it to be exceptionally useful. ...

I was searching for some good tutorials on awk. Found a very nice (brilliant indeed) article on Oracle website by Emmett Dulaney. A very good introduction for beginners. I searched for some other links as well. Have a read: 1. AWK: The Linux Administrators’ Wisdom Kit 2. A Guided Tour Of Awk 3. AWK Programming 4. UNIX Utilities - awk Happy awk’ing :) Sidhu

Today I came across a requirement where users needed to ftp files time and again. So ftp’ing again and again is not a very good option. I wrote a small batch file for the same. Just sharing the same over here. I created a folder ftp in C drive and a file get_file.bat Contents of get_file.bat are: [sourcecode language=‘css’] set /p file_name=Enter the name of the file you want to ftp: echo oracle>c:\ftp\param.cfg echo oracle123»c:\ftp\param.cfg echo cd /home/oracle»c:\ftp\param.cfg echo lcd c:\ftp»c:\ftp\param.cfg bin get %file_name% ftp -s:param.cfg 127.0.0.1 ...