Code Jutsu

Whenever I have to deal with Oracle 10g projects at work, toad always comes in handy. However yesterday, the backspace, delete and arrows button inside the SQL query editor, all of sudden, stopped working ! I can only press the other key.

I think it’s toad bug. I tried restarting the toad, even restarting the computer, but the problem persisted.

I didn’t want to uninstall/ re-install the application, so I search the problem in the google search engine.

Seems like the other people had the exact same problem, and the solution was quite simple !

To resolve the problem you have to go to toad directory installed:

C:\Program Files\Quest Software\Toad for Oracle\User Files

By default, toad installed in there. Then delete file PLSQLKEYS.BIN, you must close the toad before do it.

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 »