Code Jutsu

What is regular expression ? A regular expression is a pattern describing a certain amount of text.
You can use the oracle version 9 and above to use regular expression. In this tutorial, I will teach you all you need to know to be able to craft powerful time-saving regular expressions.

Basically there are five function to use regular expression such as regexp_count, regexp_instr, regexp_like, regexp_replace, regexp_substr. There are like count, instr, like, replace and substr function but using regular expression (regex). Read More »

We can see all view database object in oracle. We can use something like this to see all view object:

select * from all_views

You can add the filter if you want to find more specifically. See the code below

select * from all_views where view_name like '%yourkeyword%'


But if we want to search something like string or keyword in views code we can’t do query like the following : Read More »

In software development will probably have a lot of changes that we do not want. These changes might have occurred because there are the wrong code, a change from the buyer or the software for the enhancement when the maintenance. This will be very inconvenient if this change causes a change in the code.

The first thing that maybe we should do is look for codes that is affected by the change. This will be very difficult for us if the code we’ve created is very much at all.

For the following I will give tips if the changes that occur in oracle database. Read More »

Kita bisa melihat semua view yang ada di database kita dengan cara query seperti dibawah ini

select * from all_views

tetapi jika kita ingin mencari suatu string di dalam codingan view kita, kita tidak bisa melakukan query seperti dibawah ini

select * from all_views where text like '%keyword%'

query tersebut akan menyebabkan error karena type data dari kolom text adalah long. Read More »

Bermain-main dengan string lagi, heee… Apa itu regex ? regex adalah alat yang digunakan untuk bermain-main dengan string . Ha … Masih enggak nyambung ?

Misalkan kita ingin mencari suatu string yang panjangnya 20 karakter, di mana karakter ketiga adalah huruf, karakter ke empat adalah angka dan karakter ke 9 bukan huruf a,b,x,y. Ha.. Sulit sekali gimana mencarinya ya ? Read More »