Hi lll ddd,

I can tell you some definite disadvantages of Oracle (as compared to
Firebird) when you have to construct a portable application. They do
not concern specifically the topics you mention, but it would be of
concern when your project has not started yet.

NON-STANDARD VARCHAR DATATYPE
* Using SQL Varchar is not recommended by manual. VARCHAR2 is "native"
Ora. Why this deviation from the standard?
* BTW: Length limitation: 4000 bytes. Searchable up to 2000 bytes.

NON-STANDARD NUMBER DATATYPE
* Oracle has only one (1) datatype for numbers: NUMBER, whereas SQL
standard requires: INTEGER, DOUBLE, FLOAT, DECIMAL, NUMERIC.
* The Oracle Number type is implemented in a manner that is not
(repeat NOT) transparent to client applications. The consequence is
that it is nearly impossible to write a portable application that
supports both Oracle and other DBMSs such as Firebird.

NULL vs empty string
* Oracle does not distinguish between NULL value and empty string.
Empty strings (i.e. varchar, char) will save as NULL values in the
database.

CHECK CONSTRAINTS
* Oracle does not allow reference to columns outside the table's
current row.

FOREIGN KEY
* ON UPDATE CASCADE not supported.

OBJECT QUALIFICATION
* All tables, views etc. need to be qualified by an owner name, like:
<owner>.<object_name> The only way to avoid qualified object names is
to define PUBLIC SYNONYMS, for which you'll need to obtain special
privileges from the DBA.

PRIVILEGES
* Apart from the standard SELECT, INSERT, UPDATE, DELETE, REFERENCE
privileges, Oracle has distinct privileges for almost every statement,
which makes privilege management a nightmare. E.g. there are distinct
privileges for CREATE SYNONYM, DROP SYNONYM, CREATE PUBLIC SYNONYM,
DROP PUBLIC SYNONYM, etc. ad infinitum.

NON STANDARD OUTER JOIN SYNTAX
* It imposes severe limitations on the client application's SQL if the
program code needs to be portable.

AND SO ON AND SO FORTH...

Do yourself a favour and stay away from the dinosaur and go ahead with
Firebird.

Cheers,
Marco


lll ddd wrote:

>
> hi,
>
> what is advantages and disadvantages of oracle, and what is about it's
>
> 1-programming interface
> 2- hot back up
> 3- the number of connections
> 4- arabic support
> 5- scalability
> 6- (wireless support)
> 7- speed
> tell me quickly pleeeeease.
>
> thanx.
>
>
>
> ---------------------------------
> Do you Yahoo!?
> Yahoo! Tax Center - forms, calculators, tips, and more
>
> [Non-text portions of this message have been removed]
>
>
> *Yahoo! Groups Sponsor*
> ADVERTISEMENT
> <http://rd.yahoo.com/M=246920.2960106.4328965.2848452/D=egroupweb/S=1705115386:HM/A=1464858/R=0/*http://www.gotomypc.com/u/tr/yh/cpm/grp/300_Cquo_1/g22lp?Target=mm/g22lp.tmpl>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
> <http://docs.yahoo.com/info/terms/>.

--
-------------------------------------
-- Marco Bommeljé
-- Bommeljé Crompvoets en partners bv
-- W: www.bcp-software.nl
-- E: mbommelj@...
-- T: +31 (0)30 2428369
-------------------------------------