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 →

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

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 →

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 →