lunedì 28 settembre 2009

Format masks 4 Oracle Reports

NGNN0 ----> 1.234 (thousands separator)

mercoledì 23 settembre 2009

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

mercoledì 16 settembre 2009

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: