Temporary Table – ORACLE DBA » Syntax kurz erklärt

Temporary Table » Wie kann ich Innerhalb von PL/SQL mit dieser Table Variante arbeiten ?

CTPM » Business • Health • Travel • Move - Stefan Müller

Autor: Stefan Müller CEO & Senior Consultant

CTPM » Business • Health • Travel • Move

Köln • Berlin • Lindlar im Bergischen Land

Event Katalog 📅

Inhalt

1. Temporary Table
1.1 Beispiel

1. Temporary Table

1.1 Beispiel

set serverout on
begin
execute immediate 'truncate table today_emp';
execute immediate 'drop table today_emp';
execute immediate 'CREATE GLOBAL TEMPORARY TABLE today_emp
ON COMMIT PRESERVE ROWS
AS SELECT * FROM emp WHERE comm is not null';

for rec in (select * from today_emp)
loop
dbms_output.put_line (rec.ename||' - '||rec.comm);
end loop;

end;
/