Oracle PL/SQL language pocket reference
The fourth edition of this popular pocket guide provides quick-reference information that will help you use Oracle's PL/SQL language, including the newest Oracle Database 11g features. It's a companion to Steven Feuerstein and Bill Pribyl's bestselling Oracle PL/SQL Programming. Thi...
| Autor principal: | |
|---|---|
| Otros Autores: | , |
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Sebastopol, California :
O'Reilly Media, Inc
2008.
|
| Edición: | 4th ed |
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627458806719 |
Tabla de Contenidos:
- Oracle PL/SQL Language Pocket Reference, 4th Edition; Conventions; PL/SQL Language Fundamentals; Identifiers; Boolean, Numeric, and String Literals; Numeric Literals; Datetime Interval Literals; Delimiters; Comments; Pragmas; Statements; Block Structure; Variables and Program Data; Character datatypes; Unicode character datatypes; Datetime datatypes; BOOLEAN datatype; LOB Datatypes; Implicit Datatype Conversions; NULLs in PL/SQL; Declaring Variables; Constants; Default values; Anchored Declarations; Programmer-Defined Subtypes; Conditional and Sequential Control; IF-THEN-ELSE combination
- IF-THEN-ELSIF combinationCASE statement; CASE expression; Sequential Control Statements; NULL; Loops; Numeric FOR Loop; Cursor FOR Loop; WHILE Loop; REPEAT UNTIL Loop Emulation; EXIT Statement; CONTINUE Statement (Oracle Database 11g); Loop Labels; Database Interaction; Transaction Management; ROLLBACK; SAVEPOINT; SET TRANSACTION; LOCK TABLE; Autonomous Transactions; Cursors in PL/SQL; Opening explicit cursors; Fetching from explicit cursors; Closing explicit cursors; Explicit cursor attributes; Implicit Cursors; WHERE CURRENT OF clause; Dynamic Cursors; DBMS_SQL
- SQL Injection and Bind VariablesCursor Variables; Cursor Expressions; Exception Handling; Raising Exceptions; Scope; Propagation; SQLCODE, SQLERRM, and DBMS_UTILITY.FORMAT_CALL_STACK; Exceptions and DML; Records in PL/SQL; Referencing Fields of Records; Assigning Records; Records and DML; Nested Records; Collections in PL/SQL; Initializing a Collection; Adding and Removing Elements; Nested Table Functions; Collection Methods; Collections and Privileges; Nested Collections; Bulk Binds; Built-in Functions and Packages; String functions; Numeric functions; Datetime functions
- Built-in Regular Expression FunctionsREGEXP_COUNT (Oracle Database 11g); REGEXP_LIKE; REGEXP_INSTR; REGEXP_SUBSTR; REGEXP_REPLACE; Match modifiers; Built-in Packages; Stored Procedures and Functions; Functions; Parameters; Mode; Default values; Parameter-passing notations; Local Programs; Program Overloading; Forward Declarations; Table Functions; Function Result Cache; Privileges and Stored PL/SQL; Triggers; Trigger Predicates; DML Events; Compound DML Triggers; DDL Events; Database Events; Packages; Referencing Package Elements; Package Data; SERIALLY_REUSABLE Pragma; Package Initialization
- Calling PL/SQL Functions in SQLCalling Packaged Functions in SQL; Column/Function Name Precedence; Object-Oriented Features; Type Inheritance; Methods; Static methods; Constructor methods; Comparison methods; Methods in Subtypes; Manipulating Objects in PL/SQL and SQL; Upcasting and Downcasting; VALUE operator; DEREF operator; Changing Object Types; Compilation; Conditional Compilation; Compiler Warnings; Optimizing Compiler; Performing Native Compilation of PL/SQL; Oracle Database 10g; Oracle Database 11g; Java Language Integration; Publishing Java to PL/SQL; Data Dictionary
