Oracle and more - Amardeep Sidhu

My experiences with technology…

Archive for the 'Scripting' Category


Learning Regular Expressions

Posted by Sidhu on 27th February 2008

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 !

Posted in Oracle Basics, SQL, Scripting | 3 Comments »

Learning AWK…

Posted by Sidhu on 17th September 2007

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

Posted in Scripting, Unix/Linux | No Comments »

Batch file for ftp’ing files…

Posted by Sidhu on 16th July 2007

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:


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

It will create a file param.cfg having all the things like username, password and command to get the file in the same folder (c:\ftp). Then we invoke ftp with -s option with specifying the file param.cfg. It will ask the user to enter the file name and ftp the file from server to c:\ftp

Sidhu

Posted in Scripting | No Comments »