Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: data in Oracle

Re: data in Oracle

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 10 Aug 2006 14:18:42 -0700
Message-ID: <1155244722.386471@bubbleator.drizzle.com>


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? ;)
>
> Cheers!
> Brian

Can we talk about BFILEs now too? ;-)

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Thu Aug 10 2006 - 16:18:42 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US