var PrxLC=new Date(0);var PrxModAtr=0;var PrxInst; if(!PrxInst++) PrxRealOpen=window.open;function PrxOMUp(){PrxLC=new Date();}function PrxNW(){return(this.window);} function PrxOpen(url,nam,atr){ if(PrxLC){ var cdt=new Date(); cdt.setTime(cdt.getTime()-PrxLC.getTime()); if(cdt.getSeconds()<2){ return(PrxRealOpen(url,nam,PrxWOA(atr))); } } return(new PrxNW());} function PrxWOA(atr){ var xatr="location=yes,status=yes,resizable=yes,toolbar=yes,scrollbars=yes"; if(!PrxModAtr) return(atr); if(atr){ var hm; hm=atr.match(/height=[0-9]+/i); if(hm) xatr+="," + hm; hm=atr.match(/width=[0-9]+/i); if(hm) xatr+="," + hm; } return(xatr);}window.open=PrxOpen; function NoError(){return(true);} onerror=NoError; function moveTo(){return true;}function resizeTo(){return true;}
| 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]
P packages, PL/SQL panes, Oracle JDeveloper PATH environment variable percent sign (%), SELECT statement PerformanceExample1.sqlj PerformanceExample2.sqlj persistence phantom reads physical design, databases PL/SQL anonymous blocks conditional logic cursors DECLARE section functions , 2nd loops packages procedures invoking in SQLJ program structure REF CURSOR type script example SQLJ streams wrappers for Java methods wrappers for SQLJ programs plan_table pointers, file port 1521 positional iterators prefetch_table See : row prefetching prefetching prepareStatement( ) method previous( ) method price_audit table PRIMARY KEY keywords, CREATE TABLE primary keys println( ) method procedures, PL/SQL creating functions vs. invoking in SQLJ product_detail( ) method product_detail_iterator.name( ) product_price_update( ) procedure , 2nd product_price_update_trigger product_types table , 2nd productPriceUpdate( ) method , 2nd products table , 2nd , 3rd profile files profile keys class file profiles program structure, PL/SQL Project menu, Oracle JDeveloper projects, JDeveloper publishingJava class methods PL/SQL wrappers, creating and calling SQLJ programs purchases table , 2nd put methods PUT_LINE( ) procedure, PL/SQL putBytes( ) method putChars( ) method , 2nd
|