Re: Is this the sanctioned way to ascertain a table's existence?
From: joel garry <joel-garry_at_home.com>
Date: Mon, 19 Oct 2009 14:04:53 -0700 (PDT)
Message-ID: <cc6c3859-e508-4f41-b02b-836e17f72a34_at_w37g2000prg.googlegroups.com>
On Oct 19, 6:09 am, Noons <wizofo..._at_yahoo.com.au> wrote:
> Maxim Demenko wrote,on my timestamp of 19/10/2009 6:51 PM:
>
>
>
> > yes, he is counting the rows of one very specific table -
> > *user_tables* .
> > But i think, it is irrelevant as long as we agree on the subject - one
> > parse call should be more efficient than query the data dictionary.
>
> Yes, absolutely. My apologies, I misread the OP's question.
Date: Mon, 19 Oct 2009 14:04:53 -0700 (PDT)
Message-ID: <cc6c3859-e508-4f41-b02b-836e17f72a34_at_w37g2000prg.googlegroups.com>
On Oct 19, 6:09 am, Noons <wizofo..._at_yahoo.com.au> wrote:
> Maxim Demenko wrote,on my timestamp of 19/10/2009 6:51 PM:
>
>
>
> > yes, he is counting the rows of one very specific table -
> > *user_tables* .
> > But i think, it is irrelevant as long as we agree on the subject - one
> > parse call should be more efficient than query the data dictionary.
>
> Yes, absolutely. My apologies, I misread the OP's question.
Actually, you goofed up there, but OP also said:
>>> Internally, the command 'nrec' actually is a simple:
>>> SELECT COUNT(1) from :someTable;
Which could potentially be disastrous.
There could perhaps be a discussion about context switching between PL and SQL relevant to other parts of the thread http://www.google.com/search?btnG=1&pws=0&q=oracle+pl%2Fsql+context+switching .
jg
-- _at_home.com is bogus. http://www3.signonsandiego.com/stories/2009/oct/18/friends-believe-chp-officer-did-all-he-could-avoid/?metro&zIndex=184764Received on Mon Oct 19 2009 - 16:04:53 CDT