Re: data in Oracle

Brian Peasland wrote:
> DA Morgan wrote:
> > mike7411_at_gmail.com wrote:
> >> Does all data in Oracle need to be in a table?
> >>
> >> If you just want a simple lone integer that counts, say, the number of
> >> users in your database, is there an easy way to create that?
> >>
> >> Thanks.
> >
> > Syntactically yes but realistically no. External tables are really just
> > files sitting in the file system. Static data can potentially be stored
> > in package variables. But be careful what you define as "static."
>
> If the data is in an external table, then it really isn't *in* Oracle is
> it? ;)
>

If the metadata tells Oracle about it, it is. Is a ship in an uncorked bottle in the bottle? Topologically, it's not... but the physical reality is described by the shape of the bottle, and we consider that volume that could be corked, "in." So anything that Oracle knows about is within its purview.

Unless your name is Stoll.

jg

-- 
@home.com is bogus.
http://www.kleinbottle.com/