Re: Temporary Tables in Reports?

timware wrote:
>
> I am fairly new to using Oracle reports. Is there an easy way of
> generating a report which involves the use of temporary tables from a
> number of previous steps. The final report output is produced from the
> result of temporary objects created in the report
>
> eg
> step1:-
>
> create table part1 as select...etc
>
> step2:-
> create table part2 as select...etc
>
> step3:-
> select part1.a , part2.b from part1, part2 where... etc etc
> and display as a report
>
> Thanks in advance

Assuming you're using global temporary tables (which of course you should be), then you just create them in advance, and then populate them in before-report triggers et al.

Creating/dropping tables on the fly is bad bad news...

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."