| Java Programming with Oracle SQLJ | | | Copyright | | | Table of Contents | | | Preface | | | 1. Introduction | | | 2. Relational Databases, SQL, and PL/SQL | | | 3. Fundamental SQLJ Programming | | | 4. Database Objects | | | 5. Collections | | | 6. Deploying SQLJ in the JServer | | | 7. Large Objects | | | 8. Contexts and Multithreading | | | 9. Advanced Transaction Control | | | 10. Performance Tuning | | | 11. Combining JDBC, SQLJ, and Dynamic SQL | | | A. Java and Oracle Type Mappings | | | B. Oracle Java Utilities Reference | | | C. SQLJ in Applets, Servlets, and JavaServer Pages | | | Colophon | | | Index | | | Database > Java Programming with Oracle SQLJ | | Java Programming with Oracle SQLJ [Symbol][A][B][C][D][E][F][G][H][I][J][K][L][M][N][O][P][Q][R][S][T][U][V][W][X]
C C++ calc_new_price( ) function CALL statement, SQLJ CAST statement, SQLJ catch block CD-ROM CHAR datatype , 2nd oracle.sql.CHAR extension class chmod command chunks , 2nd class files , 2nd , 3rd loading into database translating SQLJ programs into class loader, JServer JVM CLASSPATH environment variable , 2nd , 3rd client.bat Client.java CLOBs (character large objects) , 2nd clob_column clob_content table host objects initializing columns putChars( ) CLOSE statement, PL/SQL close( ) method , 2nd , 3rd , 4th CLOSE_CONNECTION constant closeFile( ) method codegen option, sqlj command-line utility CollectionExample1.sqlj CollectionExample3.sqlj collections adding custom classes iterators modifying nested tables object types, storing in retrieving types VARRAY colon (\:), in Java object names , 2nd column objects adding iterators modifying attributes of retrieving comments, PL/SQL COMMIT statement , 2nd , 3rd , 4th comparison operators, SQL compilation Hello World program SQLJ compared to JDBC compiler, JServer JVM compiling custom class files components, SQLJ conditional logic, PL/SQL configuration CLASSPATH environment variable ORACLE_HOME environment variable PATH environment variable conn_context1 conn_context1.close( ) conn_context2 connect( ) method , 2nd , 3rd , 4th , 5th connection context closing database schema multiple database connections row locking specifying transactions Connection Manager dialog box, JDeveloper CONSTRAINT clause, CREATE TABLE constructors Content pane, Oracle JDeveloper content, LOB Context class ContextExample1.sqlj ContextExample2.sqlj conversation, EJB CORBA 2.0 cost-based optimization COUNT(*) function , 2nd count_customers( ) function countCustomers( ) method , 2nd , 3rd COUNTCUSTOMERS( ) method CREATE ANY DIRECTORY database privilege CREATE DIRECTORY statement CREATE FUNCTION statement , 2nd CREATE INDEX statement , 2nd CREATE PACKAGE BODY statement, PL/SQL CREATE PACKAGE statement, PL/SQL CREATE PROCEDURE statement , 2nd CREATE SEQUENCE statement, SQL CREATE TABLE OF statement CREATE TABLE statement , 2nd NESTED TABLE clause CREATE TYPE BODY statement CREATE TYPE statement , 2nd , 3rd VARRAY CREATE USER statement create( ) method , 2nd creating tables current directory, adding to CLASSPATH current_date object CURSOR clause cursors, PL/SQL CURSOR statement cursor.sql script example custom classescreating with JPublisher utility understanding class files translating and compiling customer.ejb , 2nd customer.jar Customer.java customer_iterator customer_record customer_result_set.getInt( ) customer_type.sqlj customer_typeRef.java CustomerBean.sqlj CustomerHome class compiling class file CustomerRecord class class file, compiling defined customers table , 2nd , 3rd , 4th , 5th , 6th customers_last_name_index
|