DOS command for lookup server name

C:\Documents and Settings\shijudaniel>nslookup

awk to copy ttfile to a specific folder

ll | awk ' $6=="Jan" && $7=="15" {print "cp " $9 " ../CUGDATA"}' >cugdata.sh

SQL Format Output

increasing column size for displaying the billcyclefullcode fully
------------------------------------------------------------------


SQL> column BILL_CYCL_FULL_CODE_N format 999999999999999999999999999

SQL> select BILL_CYCL_FULL_CODE_N from TABLENAME where trunc(cycle_start_date_d) = '01-NOV-2008' and rownum <10;

awk for compressing files in archive

ll | awk ' $6=="Nov" && $7=="26" {print "gzip " $9}' >26nov.sh

Touch Shell File

$ more touch.sh
for i in `ls data`
do
touch success/`basename $i success`
done

DM Checkpoints

1) Try to identify the impact of having multiple charactersets in the Source and Target Dbases.
Query to find Characterset of oracle dBase.

select * from sys.V_$NLS_PARAMETERS where parameter like '%CHARACTERSET%'
NLS_CHARACTERSET UTF8

limiation for Decode() oracle sql function

the maximum number of components in the DECODE() expression , including

expr,searches,results and default is 255.