NULLs in ANSI SQL standard

Hi
I just happened to come across a material about the ANSI SQL standards. I read the following about NULLs - an interesting phenomenon in Data bases.
The null value
Every data type includes a special value, called the null value, sometimes denoted by the keyword
NULL. This value differs from other values in the following respects:
— Since the null value is in every data type, the data type of the null value implied by the
keyword NULL cannot be inferred; hence NULL can be used to denote the null value only in
certain contexts, rather than everywhere that a literal is permitted.
— Although the null value is neither equal to any other value nor not equal to any other value —
it is unknown whether or not it is equal to any given value — in some contexts, multiple null
values are treated together; for example, the treats all null values together.
Thanks,
Soma

Monitoring OWB mappings / jobs

Hi all,

Its been a long time since i entered into this arena of OWB and oracle. Now i am back again with some quiver full of informations to share. I will share it one by one. Previously i heard about the OWB Monitoring thru Repository Audit Browser - for which we have to start the browser listner.

I have come across the following link. which is used to check the status of the running mappings.

http://kleinoracledenkraam.wordpress.com/2007/05/24/owb-monitoring/
SELECT
e.execution_name,
e.return_result,
e.creation_date,
e.last_update_date,
e.elapse,
TO_CHAR (TRUNC (SYSDATE, ‘DD’) + e.elapse / (24 * 3600), ‘HH24:MI:SS’) AS elapse_format,
wb_rt_constants.to_string (e.audit_status) AS audit_status_symbol, e.audit_status,
DECODE (x.err, NULL, 0, x.err) AS error#,
DECODE (x.sel, NULL, 0, x.sel) AS selected,
DECODE (x.ins, NULL, 0, x.ins) AS inserted,
DECODE (x.upd, NULL, 0, x.upd) AS updated,
DECODE (x.del, NULL, 0, x.del) AS deleted,
DECODE (x.dis, NULL, 0, x.dis) AS discarded,
DECODE (x.mer, NULL, 0, x.mer) AS merged,
DECODE (x.cor, NULL, 0, x.cor) AS corrected,
wb_rt_constants.to_string (m.severity) AS severity_symbol,
m.severity,
l.plain_text,
p.parameter_name,
p.value,
m.creation_date,
e.task_object_name,
e.task_object_store_name,
e.task_name,
e.audit_status,
e.top_level_audit_execution_id,
e.audit_execution_id,
e.parent_audit_execution_id
FROM
wb_rtv_audit_executions e
LEFT JOIN wb_rtv_audit_messages m
ON e.audit_execution_id = m.audit_execution_id
LEFT JOIN wb_rtv_audit_message_lines l
ON l.audit_message_id = m.audit_message_id
LEFT JOIN
(SELECT e.audit_execution_id, SUM (a.rta_errors) AS err,
SUM (a.rta_select) AS sel, SUM (a.rta_insert) AS ins,
SUM (a.rta_update) AS upd, SUM (a.rta_delete) AS del,
SUM (a.rta_discarded) AS dis, SUM (a.rta_merge) AS mer,
SUM (a.rta_corrections) AS cor
FROM wb_rt_audit_executions e
LEFT JOIN wb_rt_audit a
ON e.audit_execution_id = a.rte_id(+)
GROUP BY e.audit_execution_id) x
ON e.audit_execution_id = x.audit_execution_id
ORDER BY last_update_date DESC;


Thanks,
Soma