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

Query to find top 3rd salary in an organisation using RANK function

select empname, salary
from (select empname,salary ,rank() over(order by salary desc) sal_rank from EMPLOYEE)
where sal_rank=3

(From Oracle 9i onwards)

About Managed Services(in Telecom)

Major Advantage/Requirement/VAlue add of managed services operations in telecom sector is that service provider are expected to resolve the problems when they arise or to fix faults before the customers or end users realize there is a fault.

Billing Concepts

Hot Billing//Real Time Billing or Warm Billing//Near Real Time Billing
=================================================
1) Hot Billing //Real Time Billing :--> Processing CDRs within 1 minute of call completion.

2) Warm Billing//Near Real Time Billing :--> Processing CDRs within 5 minutes of call completion.

Telecom Products and offers

Products and Offers
====================
Products (Packages) and offers (promotions) can be assigned (or sold) to subscribers.
A Product is a way of charging a customer during a period and determines what the
customer gets charged at the end of a billing period.

Offers are similar to packages, except that they are valid only for a certain period
and are used to provide special services or rates to the subscriber.
A product /offer consists for following components.
a) One time charges
b) advance rentals
c) rentals
d) initial charges
e) discounts
f) services
g) variable tariffs
h) tariffs (attached with products only)
(Technical services//Profit_Cost centers also attached to offers and products)

Churn

Churn
------

Used in Telcos to describe the turnover rate in the number of
subscribers to a service or product. Churn rate indicates that
subscribers are swithcing to a different service or company,
or eliminating service altogether.Telcos need to keep current customers
happy and to reacquire previous subscribers.

Methods to elimiate customer churn.
-----------------------------------
1)Business promotions with a metric to track its success rate.
2)Loyalty programs

String manipulation using Excel Nested Functions

Convert number +91 (11) 2000-5658 to 20005658


=int(CONCATENATE(MID(B2,SEARCH("+91",B2)+9,4),MID(B2,SEARCH("-",B2)+1,4)))


Happy New Year 2010 to all Blog Readers.