Re: PL/SQL Question

Curtis wrote:

> Works like a charm now! :) Thanks!
>
> Curtis

The fact that you "can" do it doesn't mean you ever "should."

If the point of this exercise was that you have come to Oracle from another RDBMS, like SQL Server, and you want to build temporary tables: Don't!

First get a copy of Tom Kyte's book "Expert one-on-one Oracle" and read the first three chapters with care.

Second carefully read the Oracle concept and architecture docs at http://tahiti.oracle.com.

Third learn about global temporary tables.

That you "can" do something does not equate with you "should."

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)