Re: 'temp' oracle tables

>Gopal wrote:
>
> There is no temporary table in Oracle.
>

And in the same sense there's no such thing as a 'permanent job' ;)

If you want temporary tables in Oracle you can:

1. Create a permanent table of the structure you need plus a column to slice by process/proc.
2. Include the functionality to create/remove a table within the proc itself.
3. Use PL/SQL tables.

Chose which ever suites, but don't forget to clean up afterwards!

Martin

martinb_at_hooked.net

#	Technomation, Inc.
#
#	Client-Server Design, Implementation, Management.
#