| 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]
S sample_files directory saveFile( ) method , 2nd , 3rd schemas , 2nd , 3rd JDeveloper browser SCOPE IS clause script example, PL/SQL scripts, executing scrollable result set scrollable result set iterators Search menu, Oracle JDeveloper security SELECT INTO statement, SQL SELECT statement AND operator ASC keyword asterisk BETWEEN operator DESC keyword equality operator (=) IN operator LIKE operator LOB locator, retrieving nested tables NOT BETWEEN operator NOT IN operator OR operator ORDER BY clause REF operator VARRAY, retrieving WHERE clause semantic checking SERIALIZABLE, transaction isolation level server_example1 package server_examples.sql ServerExample1 class , 2nd ServerExample1.class ServerExample1.jar ServerExample1.sql ServerExample1.sqlj ServerExample1_SJProfile0.class ServerExample1_SJProfileKeys.class ServerExample2.class ServerExample2.sqlj ServerExample2_SJProfile0.class ServerExample2_SJProfileKeys.class servlet, SQLJ ServletExample.sqlj , 2nd servlets embedding SQL statements inside Oracle JDeveloper SessionBean interface set mutator methods SET SERVEROUTPUT ON command , 2nd , 3rd SET statement, SQLJ , 2nd SET TRANSACTION statement setArray ( ) function setBatching( ) method , 2nd setBatchLimit( ) method setCity( ) method setDefaultContext( ) method setDefaultRowPrefetch( ) method , 2nd setElement( ) function setFetchDirection( ) method setMaxRows( ) method setQueryTimeout( ) method setSessionContext( ) method setState( ) method setStreet( ) method setValue( ) method , 2nd setZip( ) method sharing database connections short datatype Short class , 2nd short name, Java class objects SID (system identifier) , 2nd signatures, method simple loops, PL/SQL single-row queries, SQLJ size_of_chunk Smalltalk sorting, SELECT statement results specification, EJB specifications, defining for object types SQL (Structured Query Language) AND operator BETWEEN operator COMMIT statement CREATE TABLE CREATE USER DDL statements, purpose of DELETE statement DML statements dynamic static vs. , 2nd IN operator INSERT statement LIKE operator NOT BETWEEN operator NOT IN operator OR operator Oracle database types ORDER BY clause ROLLBACK statement ROWID schemas SELECT, single-table table joins transactions tuning UPDATE statement WHERE clause , 2nd SQL*Plus , 2nd , 3rd , 4th sql.CLOB class sql_statement sql_warning SQLException class , 2nd , 3rd SQLJ applets CALL statement creating programs JDBC, compared to JServer JVM, designing programs for in JSP PL/SQL publishing REF column, dereferencing runtime packages servlet translating programs translating programs into class files SQLJ 9i sqlj directory sqlj utility , 2nd , 3rd , 4th , 5th options, listed SQL statement semantics, checking SQLJ Wizard dialog box sqlj.runtime.* sqlj.runtime.AsciiStream sqlj.runtime.BinaryStream sqlj.runtime.ConnectionContext interface sqlj.runtime.ExecutionContext sqlj.runtime.ExecutionContext class , 2nd sqlj.runtime.ref.* sqlj.runtime.ref.DefaultContext class , 2nd sqlj.runtime.Scrollable interface , 2nd sqlj.runtime.UnicodeStream sqlj_conn_context , 2nd SQLJ_PROJECT sqlj_project.jpr , 2nd , 3rd sqlj_workspace.jws , 2nd , 3rd SQLNullException class SQLWarning object start( ) method stateful session beans (EJB) STATEFUL_SESSION stateless session beans (EJB) STATELESS_SESSION statement trigger static SQL statements , 2nd STORE AS keyword See : procedures, PL/SQL stored procedures stream host object stream objects StreamExample1.sqlj StreamExample2.sqlj streams closing retrieving content from LOBs storing content in LOBs strings JDBC 1.x, mapping to Oracle types String class Struct datatype STRUCT type Structure pane, Oracle JDeveloper See : SQL Structured Query Language stubs, method Sun Microsystems Sybase syntax checking SQLJ compared to JDBC system identifier (SID) , 2nd system requirements System.out.println( ) , 2nd
|