$dbh->do("
    CREATE GLOBAL TEMPORARY TABLE HR.Tempest(
        ID INT,
        NAME VARCHAR2(25),
        TITLE VARCHAR2(50),
        DEPT VARCHAR2(100)
    ) ON COMMMIT PRESERVE ROWS
");
$dbh->commit();

# Tell the database to select the rows of interest and populate the
# temporary table with them
$dbh->do("
    INSERT INTO HR.Tempest
    SELECT e.employee_id, e.first_name, j.job_title, d.department_name 
    FROM   HR.employees e, HR.jobs j, HR.departments d
    WHERE  e.job_id = j.job_id
    AND    e.department_id =  d.department_id
");
$dbh->commit();