Re: Temprorary Tables
From: Leng Kaing <leng_at_cougar.vut.edu.au>
Date: 1996/11/22
Message-ID: <5741d6$7vr_at_cougar.vut.edu.au>#1/1
Date: 1996/11/22
Message-ID: <5741d6$7vr_at_cougar.vut.edu.au>#1/1
L. Tseng (lesliet_at_u.washington.edu) wrote:
: Would you mind sharing some thoughts about how to create
: a temp table in a procedure, populate it, loop thru it, and
: then drop it? Thank you,
: Lesliet
Use dbms_sql. I've used this for create users and should work for create tables. Lately I've also heard that of dbms_ddl which should allow for DDLS's. Haven't tried this myself.
Leng.
-- Leng Kaing - Database Consultant Common Sense Consulting Phone: +61-3-9885-5829 (ext 46) Email: leng_at_comsense.com.au WWW: http://dingo.vut.edu.au/vougReceived on Fri Nov 22 1996 - 00:00:00 CET