Re: data in Oracle

From: Brian Peasland <dba_at_nospam.peasland.net>
Date: Thu, 10 Aug 2006 19:15:38 GMT
Message-ID: <J3squ4.8E3@igsrsparc2.er.usgs.gov>

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

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

Received on Thu Aug 10 2006 - 14:15:38 CDT