Skip to Main Content
Oracle PL/SQL Programming: A Developer's Workbook
book

Oracle PL/SQL Programming: A Developer's Workbook

by Steven Feuerstein, Andrew Odewahn
May 2000
Intermediate to advanced content levelIntermediate to advanced
594 pages
11h 32m
English
O'Reilly Media, Inc.
Content preview from Oracle PL/SQL Programming: A Developer's Workbook

Chapter 26. Using Java with PL/SQL

Beginner

Q:

26-1.

(c). Oracle8i’s Java Virtual Machine is called Aurora (Aur-ora…get it?)

Q:

26-2.

The statements are:

  1. False. Java stored procedures are fundamentally different from Java applets because they are compiled and stored in the database.

  2. False. Oracle8i allows you to call Java procedures from PL/SQL, allowing you to take advantage of the hundreds of prebuilt (and third-party) classes.

  3. True. You can call Java stored procedures from SQL or PL/SQL via PL/SQL wrappers, from Java applets via JDBC or SQLJ, from Pro*C via OCI (the Oracle Call Interface), and from Visual Basic or Oracle Forms via ODBC (Open Database Connectivity).

  4. False. Java is a true object-oriented language; PL/SQL, while it has some OO properties, is primarily a procedural language.

  5. True. The Java foundation classes contain a rich set of operations, such as file I/O and networking, that you can exploit in your PL/SQL programs.

  6. False. Java and PL/SQL are equals in the database.

  7. False. Java is controlled by Javasoft, a division of Sun Microsystems. While Java is more open than PL/SQL, it is still (for now, at any rate) under the control of a single entity.

  8. True. Java was designed as a “write once, run anywhere” language, so it’s fairly easy to run on a variety of platforms with very little effort.

  9. False. Java programs are compiled into an intermediate form called bytecode that is interpreted by a Java Virtual Machine such as Aurora.

  10. True. Java, like C and C++, is case-sensitive.

Q:

26-3.

(b). ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Database 12c PL/SQL Programming

Oracle Database 12c PL/SQL Programming

Michael McLaughlin
Oracle PL/SQL for DBAs

Oracle PL/SQL for DBAs

Arup Nanda, Steven Feuerstein
Oracle PL/SQL For Dummies

Oracle PL/SQL For Dummies

Michael Rosenblum, Paul Dorsey

Publisher Resources

ISBN: 9781449324070Supplemental ContentErrata Page