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.

meaning of word "Shiju" from internet

http://www.orientaloutpost.com/dictionary.php?q=shiju&t=english

Interconnect Billing Concepts

In Telecommunication, Interconnection agreements allows one operator to use the networks of other operators, including their physical infrastructure and software systems. Each operator can give users of its own network access to the user or services of other networks based on certain interconnection agreements. One of the key regulatory objectives in Telecommunications is to ensure that operators conclude such agreements under equitable conditions.

Normally there are two types of agreements(1) Roaming and (2) Interconnect.

In interconnection terminology the other network operator whom we are providing service is named as "Partner", for configuring the same at the BSS platform, one need to provide certain informtaion such as (1) Partner Code (2) Partner ShortCode/PLMN Code (Public Land Mobile Network code (3) Partner Group (GSM/PSTN/CDMA/3G etc) (4) Operational Domain (International/Domestic etc) (5) UTC (Universal Time Coordinate) or Greenwich time (6) POI (Point of Interconnect) (7) IMSI prefix of the partner (8) Partner valid from which date (9) Transfer type(Incoming//Outgoing//Bi directional) (9) Rating Zone (Group of destinations having same rates) (10) and a lot based on the platform you are using.

Macedonian Greetings for Xmas

Good Evening and Happy Christmas Eve ==> "Dobra Veccer I Vesel Badnik"

Christ is Born ==> "Hristos Se Rodi"

Indeed, He is Born ==> "Voistinu Se Rodi"

Display numeric value in words using SQL

SQL> select to_char(to_date(123,'J',),'JSP') from dual;

output as below

ONE HUNDRED TWENTY-THREE