Cargando…
Oracle PL/SQL programming /
For the past ten years, O'Reilly's Oracle PL/SQL Programming has been the bestselling book on PL/SQL, Oracle's powerful procedural language. Packed with examples and helpful recommendations, the book has helped everyone--from novices to experienced developers, and from Oracle Forms de...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Otros Autores: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Sebastopol, Calif. :
O'Reilly,
2005.
|
| Edición: | 4th ed. |
| Temas: | |
| Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
Tabla de Contenidos:
- Oracle PL/SQL Programming, 4th Edition; Structure of This Book; What This Book Does Not Cover; Conventions Used in This Book; Which Platform or Version?; About the Code; Safari Enabled; Comments and Questions; Acknowledgments; I. Programming in PL/SQL; 1.2. The Origins of PL/SQL; 1.2.2. Improved Application Portability; 1.2.3. Improved Execution Authority and Transaction Integrity; 1.2.4. Humble Beginnings, Steady Improvement; 1.2.5. The Significance of Oracle Database 10g PL/SQL; 1.3. So This Is PL/SQL; 1.3.2. Control and Conditional Logic; 1.3.3. When Things Go Wrong
- 1.4. About PL/SQL Versions1.4.1.2. Compile-time warnings; 1.4.1.3. Conditional compilation; 1.4.1.4. Support for nonsequential collections in FORALL; 1.4.1.5. Improved datatype support; 1.4.1.6. Backtrace an exception to its line number; 1.4.1.7. Set operators for nested tables; 1.4.1.8. Support for regular expressions; 1.4.1.9. Programmer-defined quoting mechanism; 1.4.1.10. Many new built-in packages; 1.5. Resources for PL/SQL Developers; 1.5.2. PL/SQL on the Internet; 1.6. Some Words of Advice; 1.6.2. Don&t Be Afraid to Ask for Help; 1.6.3. Take a Creative, Even Radical Approach
- 2. Creating and Running PL/SQL Code2.1.2. Running a SQL Statement; 2.1.3. Running a PL/SQL Program; 2.1.4. Running a Script; 2.1.5. What Is the ""Current Directory?""; 2.1.6. Other SQL*Plus Tasks; 2.1.6.2. Saving output to a file; 2.1.6.3. Exiting SQL*Plus; 2.1.6.4. Editing a statement; 2.1.6.5. Loading your own custom environment automatically on startup; 2.1.7. Error Handling in SQL*Plus; 2.1.8. Why You Will Love and Hate SQL*Plus; 2.2. Performing Essential PL/SQL Tasks; 2.2.2. Executing a Stored Program; 2.2.3. Showing Stored Programs
- 2.2.4. Managing Grants and Synonyms for Stored Programs2.2.5. Dropping a Stored Program; 2.2.6. Hiding the Source Code of a Stored Program; 2.3. Calling PL/SQL from Other Languages; 2.3.2. Java: Using JDBC; 2.3.3. Perl: Using Perl DBI and DBD::Oracle; 2.3.4. PHP: Using Oracle Extensions; 2.3.5. PL/SQL Server Pages; 2.3.6. And Where Else?; 3. Language Fundamentals; 3.1.2. Named Blocks; 3.1.3. Nested Blocks; 3.1.4. Scope; 3.1.5. Visibility; 3.1.5.2. Qualified identifiers; 3.1.5.3. Qualifying identifier names with module names; 3.1.5.4. Nested programs; 3.2. The PL/SQL Character Set
- 3.3. Identifiers3.3.1.2. Identifiers from STANDARD package; 3.3.1.3. Approaches to avoiding reserved words; 3.3.2. Whitespace and Keywords; 3.4. Literals; 3.4.2. Embedding Single Quotes Inside a Literal String; 3.4.3. Numeric Literals; 3.4.4. Boolean Literals; 3.5. The Semicolon Delimiter; 3.6. Comments; 3.6.2. Multiline Comment Syntax; 3.7. The PRAGMA Keyword; 3.8. Labels; II. PL/SQL Program Structure; 4.1.2. The IF-THEN-ELSE Combination; 4.1.3. The IF-THEN-ELSIF Combination; 4.1.4. Nested IF Statements; 4.1.5. Short-Circuit Evaluation; 4.2. CASE Statements and Expressions