internal

Oracle: list of the system events

Monday, November 3rd, 2008

set serveroutput on
declare
event_level number;
begin
dbms_output.enable(20000) ;
for i in 10000..33999 loop
sys.dbms_system.read_ev(i,event_level);
if (event_level > 0) then
dbms_output.put_line(’Event ‘||to_char(i)||’ set at level ‘||
[...]

Oracle: sql types

Friday, October 10th, 2008

Here is the list of the Oracle SQL types and their internal codes:

SELECT t.typecode,o.name
FROM sys.type$ t, sys.obj$ o
WHERE
BITAND (t.properties, 16) = 16
AND t.toid = o.oid$
ORDER BY t.typecode