Re: PLSQL: how to test if a table exists?

jhking wrote:

> That having been said I worked recently in a poor man's data warehouse
> environment where I was gathering data from several dblinks to remote
> sites with 300-odd nearly identical tables. Using a data-driven,
> execute immediate style approach was the only way to get the data
> gathering part done in a reasonable amount of development time.

> <snipped>

So you say. ;-)

I think Sybrand, and I almost certainly, would argue that your assumption that it was the only way to do it in a reasonable amount of time is not valid.

Perhaps it is the only way you know how. But that may not hold true for others. I would suggest a re-examinination of your assumptions.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)