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.

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.

Build a .NET Application on the Oracle Database with Visual Studio 2005 or 2008

Interesting quick tutorial about Oracle and Visual Studio: LINK