Re: Foreign key in Oracle Sql

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Fri, 21 Jan 2005 13:18:15 -0800
Message-ID: <41f1718b$1_2_at_127.0.0.1>


Hugo Kornelis wrote:

> However, I'm afraind you've left out an important detail. According to
> http://oraclestore.oracle.com/OA_HTML/ibeCCtpSctDspRte.jsp?section=11365&media=os_user_minimums,
> there is a minimum of 5 Named User Plus licenses for SE1, so the licensing
> cost for a small company is still USD 500, plus an additional USD 100 for
> every user above 5 that wants to connect to the database.

> MSDE is free. That's 100% cheaper.

Lets not forget support eh.
Lets not forget what one is actually getting. If all you want is a basic black-hole into which you can dump data then you realistically aren't an Oracle customer. But if you want what Oracle is offering, which is not a relational database but rather a full object-relational development environment ... you aren't getting that from Microsoft at any price.

> The down side is that no front-end tools are included,

Whereas all of the Oracle tools developed anywhere work with SE1 from the free version of TOAD on up and everything developed is 100% compatible with the Enterprise Edition not a single code change required.

  but those are not needed anyway for use with an ERP
> package. Database size is limited to 2GB (plenty for small to medium sized
> companies) and performance will be throttled when more than 5 user
> processes are simulteanously active.

Where did this come from? Can you point me to the source?

>>Now would you like to compare feature sets with MSDE?
>>Any time you're ready have at it.

>
> Sorry, not interested. All my current code expects ANSI-standard behaviour
> of empty strings. As long as Oracle can't do that, there's no way in the
> world that I'm going to port my code to Oracle.

And there is no way you need what Oracle is selling. A better question to ask based on your requirements is why not just go to MySQL or PostgreSQL or Firebird? And why are you typing yourself to a single vendor's chipset and operating system?

>>You can disagree with me. That is your right. But what would be your
>>point?

>
> None. I've just stated my opinions.
>
> Best, Hugo

That's all any of us do. Have a great day.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)


----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= East/West-Coast Server Farms - Total Privacy via Encryption =---
Received on Fri Jan 21 2005 - 22:18:15 CET

Original text of this message