Once I have tried to evaluate inheritance in 9.0.1. Database started to give
me ora-600's, no development tools for that, unstable, not very well
documented. I didn't make much efforts, though.
Is here anyone who had experience with inheritance and type evolution in
PL/SQL? How does it feel?
--
Alexandre
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
Sent: Wednesday, June 19, 2002 4:48 PM
> Below is copied verbatim from the 9i R2 doc. set.
>
> Java versus PL/SQL
> Both Java and PL/SQL can be used to build applications in the database and
will have future performance improvements. Here are
> guidelines for their use:
>
> PL/SQL Is Optimized for Database Access
> PL/SQL uses the same datatypes as SQL. SQL datatypes are thus easier to
use and SQL operations are faster than with Java,
> especially when a large amount of data is involved, when mostly database
access is done, or when bulk operations are used.
>
> PL/SQL Is Integrated with the Database
> PL/SQL is the extension to SQL and uses the same datatypes. PL/SQL has
data encapsulation, information hiding, overloading, and
> exception-handling.
>
> Some advanced PL/SQL capabilities are not available for Java in Oracle9i.
Examples are autonomous transactions and the dblink
> facility for remote databases. Code development is usually faster in
PL/SQL than when using Java.
>
> Both Java and PL/SQL Have Object-Oriented Features
> Java has inheritance, polymorphism, and component models for developing
distributed systems. PL/SQL has inheritance and type
> evolution, the ability to change methods and attributes of a type while
preserving subtypes and table data that use the type.
>
> Java Is Used for Open Distributed Applications
> Java has a richer type system than PL/SQL and is an object-oriented
language. Java can use CORBA (which can have many different
> computer languages in its clients) and EJB. However, PL/SQL packages can
also be called from CORBA or EJB clients.
>
> You can run XML tools, the Internet File System, or JavaMail from Java.
>
> Many Java-based development tools are available throughout the industry.
>
>
> --
> Charlie Mengler Maintenance Warehouse
> charliem_at_mwh.com 10641 Scripps Summit Ct.
> 858-831-2229 San Diego, CA 92131
> There are no stupid questions, but there are many inquisitive idiots!
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Charlie Mengler
> INET: charliem_at_mwh.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Alexandre Gorbatchev
INET: alexandre.gorbatchev_at_avermann.de
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Wed Jun 19 2002 - 11:33:27 CDT
