Window XP Service Pack

When you need XP Service Packs, it's always difficult to find them!

So, Here they are:

Download SP1

Download SP2

Download SP3

Form Grep & Form Diff

did you ever want to find code fragments into a set of Oracle Forms?
Form Grep is the solution

I also found very useful Form Diff, a software which allows you to locate differences between 2 Forms.

EDIT
A cheaper solution to find some text into a form (*.fmb *.fmx), library (*.pll *.plx) or report (*.rdf *.rep).
Under Linux simply type:

find . | xargs grep 'string' -sl

The -s is for summary and won't display warning messages such as grep: ./directory-name: Is a directory

The -l is for list, so we get just the filename and not all instances of the match displayed in the results.

Table Partitioning, step by spep

1. log in as system

2. create tablespaces for partitioned tables:

-- data tablespace
create tablespace data_2020 datafile 'Z:\ORACLE\ORADATA\CDEP\DATA_2020.DBF'
size 25M reuse default storage (next 160k pctincrease 0);

-- indexes tablespace
create tablespace index_2020 datafile 'Z:\ORACLE\ORADATA\CDEP\INDEX_2020.DBF'
size 25M reuse default storage (next 160k pctincrease 0);

3. submit the alter tabe command for each table to be partitioned:

ALTER TABLE TABLE1 ADD PARTITION DEP_2020
VALUES LESS THAN (2021)
storage (initial 480k) TABLESPACE data_2020;

ALTER INDEX TABLE1_PK REBUILD PARTITION DEP_2020
storage (initial 400k) TABLESPACE index_2020;

Format masks 4 Oracle Reports

NGNN0 ----> 1.234 (thousands separator)

Find locks with Oracle

Most Oracle professionals use of the v$locked_object view in order to gather information about objects that are locked within the Oracle database.

Full article

How to check a number: a function IsNumber in PL/SQL

function IsNumber(val1 varchar2) return varchar2 is
n number;
begin
n:=val1;
return 'T';
exception
when others then
return 'F';
end;

See also:

Execute a procedure under another schema

Problem:
There are two users, A and B.
User A creates a procedure.
User B wants to run that procedure, but he wants to affect the tables of his own schema, not the tables of user A!

Solution:
You can simply add

authid current_user

in the package specification

Authid clause immediatly follows the create procedure, create function, create package or create type statement.