UTL_MATCH – string similarity/matching 11G

UTL_MATCH is very interesting package which implements quite advanced algorithms to match two strings. You can use them to quickly match name like First Names or Last Names.

Two basic algorithms are implemented here:

Edit Distance” – is a measure of Similarity between two strings, s1 and s2. The distance is the number of insertions, deletions or substitutions required to transform s1 to s2

Jaro-Winkler algorithm” is another way of calculating Edit distance between two strings. It is a String Comparator measure that gives values of partial agreement between two strings. The string comparator accounts for length of strings and partially accounts for typical human errors made in alphanumeric strings

Continue reading

NLS_NUMERIC_CHARACTERS as easy as possible

In this article I present how NLS_NUMERIC_CHARACTERS parameter works.

This parameter specifies the characters to use as group separator and decimal character. The group separator separates integer groups (that is, thousands, millions, billions, and so on). The decimal separates the integer portion of a number from the decimal portion.

NLS_NUMERIC_CHARACTERS = “decimal_character group_separator”

Continue reading

Install Oracle Enterprise Manager 12C release 2(12.1.0.2) on OEL 5/6

This article presents installation of new Oracle Enterprise Manager 12C version 12.1.0.2 on OEL5, OEL6. You need at least 5GB of memory for this installation so check your VirtualBox settings before proceeding.

Read following article to find out how to install OEL5,6 and database 11G Linux. They are required for this installation:

This installation was done on OEL5 but it’s no different on OEL6(extra library must be installed)

Continue reading

Limit on IN clause ORA-01795

There is a limit of of values that can be specified for IN clause. The limit is 1000 expressions. In case you try to to write following query you can get ORA-01795

Select
 shogen_no,
 shogen_desc,
 disp_turn
 From
 shogen
 where
 shogen_no in ('one', 'two', 'three', ..........'more than thousand')

solution is quite simple you need to write many IN caluse

where
 shogen_no in ('one', 'two', 'three', ..., 'first thousand') or
 shogen_no in ('four', 'five', 'six', ..., 'another thousand') or ...

Have a fun 🙂

Tomasz

 

Sqldeveloper remote debugger

This article presents how to use remote debugger in Sqldeveloper.

It’s recommended to read article about debugging code in sqldeveloper:

Sqldeveloper debugger

Remote debuger is very nice feature of sqldeveloper. It gives possibility to a Developer to debug a code started in different session by a Client.So somebody else (on completly different computer) is starting code and we just debug it. It’s like setting a bait(by Developer) and wait for careless animal 🙂 (Client).

Continue reading

Sqldeveloper debugger

This article presents how to use debugger in Sqldeveloper.

Oracle SqlDeveloper is very popular application between developers. I’d like to show you how easy you can debug your code.

First you need to create simple procedure and compile it for debug. You can do it in sqldeveloper if you want

CREATE OR REPLACE PROCEDURE my_code
IS
  v_id NUMBER := 5;
BEGIN
  FOR i IN 1..v_id
  LOOP
    DBMS_OUTPUT.put_line(i);
  END LOOP;
END;
/
 
ALTER PROCEDURE my_code compile debug;

Continue reading

Install Oracle 11G Release 2 (11.2) on Fedora 18

This article presents how to install Oracle on Fedora 18.

Read following article howto install Fedora 18 Linux: Install Fedora 18 (for comfort set 2G memory for your virtual machine before proceeding with Oracle software installation).

Installation software is available on OTN version 11.2.0.1 or metalink 11.2.0.3. In this installation I’m presenting installation for 11.2.0.3 but for previous version 11.2.0.X it shouldn’t be different.

Continue reading

Install Fedora 18

This article presents how to install Fedora 18.

I assume you have already downloaded Fedora 18 64 bit(about 4 G)  and you know how to use VirtualBox 64 bit(100M). Create virtual machine with default settings for Linux Fedora 64 bit. 1GB ram and 32G for disk is enough plus increase video memory to 128M and turn on acceleration 3D. Rest of options you can keep default.

Continue reading