If you have read my previous tip about Oracle XML API
You would learn to use XML API as nice quick’n’dirty replacement to tons of decode functions.
In this challenge I got on Oracle 9i (yes they still exist in production 2013).
- We have a string such as ‘123#124#122’, we need to split the different values into record , sort them and map them from a Value-key pair table in an Oralce 9i database.
- And for reasons of implementation it has to be done in pure SQL, not PL/SQL.
- and it is best to avoid creating any stored procedures or functions.
A more elaborate description of the problem : Splitting a delimited text with Oracle SQL into records, and sorting them out.
This is a real challenge in the production environment I’m working in.
Read more »
Tags: delimited, function, Oracle, Oracle XML, Oracle9i, PLSQL, Split, Split Function, SQL, string, XML, XMLAPI, XMLDB
BSCS, Oracle, SQL, XML | asmaklad, 11 Sep 13 | 
Comments Off on Yet another Oracle XML challenge
I had the privilege to attend JAZOON software development conference in Zurich. I heard a lot of buzzwords and jargon there about the new technologies of the software development. from the group of seminars and keynotes there I generated a picture about the perfect Enterprise application in the future. In this article I try to paint this picture.
Read more »
Tags: agile. assessment, human interface, Java, javascript, JBoss, NOSQL, Open Source, Oracle, Scala, Scrum, v-model, Web
Java, JEE, Telecom Billing, Web Technologies | asmaklad, 3 Jul 12 | Comments Off on The Enterprise applications of the future.
Introduction:
Billing systems in telecom are pivotal for the operation of any telecom operator. In this article I explain some of the terminologies about telecom and try to show how they fit in the big picture in telecom operators.
Also I explain the Customer, Network and Money triangle which helps in defining functionalities of the Billing system and maybe IT Applications inside the telecom operator matrix of business processes.
The ideas discussed in this article is intended to be as generic as possible and based on my personal perspective.
Read more »
Tags: Billing, BSCS, Business Model, ERD, GSM, SIM, telecom
BSCS, Introduction, Oracle BRM, Telecom Billing, Uncategorized | asmaklad, 12 Nov 10 | Comments (7)