In this post, I will show two simple ways to create a StringTokenizer function in PL/SQL. One way is to use regular expressions using the functions REGEXP_SUBSTR and REGEXP_INSTR provided by Oracle. The Functions REGEXP_SUBSTR and REGEXP_INSTR are merely an extension of their function INSTR and SUBSTR in Oracle. The STRINGTOKENIZER_REGEX function, which you can see below, it behaves like the class StringTokenizer in Java, that’s by removing all the tokens that are NULL. The result will be a DBMS_SQL.varchar2_table with all valid tokens. Let’s see, now, the code:
A StringTokenizer Function in PL/SQL
October 9th, 2009 — Database
Improve your Blog - 4 - Post Length & Frequency are Important?
September 21st, 2009 — Wordpress, tips&tricks
The hardest thing to do for a blogger is to update as often as possible their blog. Very often the passion for the topics could not be enough, because you have to spend all time for the commitments and contingencies of life so you don’t have more time to dedicate to your blog.
Continue reading →
Continue reading →
Improve your Blog - 3 - Choosing the Content to Write
September 14th, 2009 — Wordpress, tips&tricks
The most important thing for a Blog is its content. It’s necessary to understand what you want to write if you want to become a good blogger. I think the first thing is that you must only write about topics that you’re passionate. Continue reading →
Object Oriented Concepts: Encapsulation
September 2nd, 2009 — Java, Object Oriented
This Post deal with one of the fundamental concepts about Object Oriented which is called Encapsulation. If you want to aspire to a good Object Oriented Design that’s one of those “rules” to follow . The Encapsulation is an arguments to know if you want to overcome with success the Sun Certified Programmer for the Java Platform too. It’s contained in the Objective 5.1 of section 5.
PL/SQL Integration - Part 1 - Using External Services
April 17th, 2009 — Database, System Integration
More and more we need, for several reasons, to integrate the legacy systems with external services. In this post, we only briefly describe some possible integration between client-server legacy systems, with business logic written in PL/SQL, and Java Services. Continue reading →
Improve your Blog - 2 - Choosing the Theme
April 1st, 2009 — Wordpress, tips&tricks
When you need to create a new blog with Wordpress, you have to define the layout and the design of our web site. To do so, you must to create or choose a Wordpress Theme . If you have no experience, it’s better to start choosing a free Wordpress Theme. There are so many free themes on internet. Try to search with Google. Continue reading →
Improve your Blog - 1 - Choosing the blog platform
March 21st, 2009 — Wordpress, tips&tricks
The first thing you need to decide is whether using a free blog service like wordpress.com or whether building an own blog, subscribing a web hosting service and buying a domain. In both cases there are so many possible solutions.
Continue reading →
Installing Apache2 on Unix-Like System
March 11th, 2009 — Apache, Linux, Tutorial, Unix-Like System
This post is a step-to-step tutorial to install Apache 2 from source-code on Unix-Like Systems like Linux, Open Solaris and FreeBSD.
Continue reading →
