Re: Reporting with dynamic sql

From: G Quesnel <dbaguy_ott_at_yahoo.com>
Date: 16 Aug 2006 05:34:32 -0700
Message-ID: <1155731672.724763.323970@74g2000cwt.googlegroups.com>

Do you realize that two users accessing the same temp table don't see each others' data. I wasn't sure you got that based on your comment. I almost never create tables on the fly (multiple tables created with varying name, programatically), but frequently use "execute immediate" inside PL/SQL to deliver schema modification in a release upgrade.

>It looks like dynamic sql and SQL*Plus report capabilities don't mix very well

I don't agree. You just need to get more familiar with them. If you want to mix variables to hold tablespace name and extent sizes with execute immediate and show the resulting statement, or # of rows updated , or ... in dbms_output. Mix it all in with regular SQL inbetween anonymous block and you get something pretty powerfull.

HTH Received on Wed Aug 16 2006 - 07:34:32 CDT