Glotzfisch.de

CREATE OR REPLACE PROCEDURE write_log (
   error_id IN NUMBER
   ,msg     IN VARCHAR2
)
IS
PRAGMA AUTONOMOUS_TRANSACTION;

BEGIN
  insert into zzz_errors (timestamp, error_code, message) VALUES (SYSDATE,error_id,msg);
  commit;
END write_log
[...more...]				

update (
   SELECT * FROM temp_dim tableIn,
                 temp_dates dates1,
	         temp_dates dates2
   WHERE dates1.ID = tableIn.VALID_FROM
   AND   dates2.ID = tableIn.valid_to
   AND SYSDATE BETWEEN dates1.FULL_DATE AND dates2.full_dat
[...more...]				

 CREATE OR REPLACE PROCEDURE ausgabe (text IN VARCHAR2?)
   IS
	  n NUMBER;
	  m NUMBER;
	  i NUMBER;
	  j NUMBER;

[...more...]				

 select 
 eff_date,
 sum(number_of_items)
 from
 (select 
    to_char(effective_report_date,'mmyyyy') as eff_date,
    count(*) number_of_items
    from dm1
    where to_char(effective_report_date,'mmyyyy') = '082004'
    group by to_char(e
[...more...]