Oracle PL/SQL Programming: A Developer's Workbook
Steven Feuerstein, Andrew Odewahn
Format: PDF / Kindle (mobi) / ePub
However excellent they are, most computer books are inherently passive--readers simply take in text without having any opportunity to react to it. The Oracle PL/SQL Developer's Workbook is a different kind of animal! It's designed to engage you actively, to get you solving programming problems immediately, and to help you apply what you've learned about PL/SQL--and in the process deepen your knowledge of the language. By tackling the exercises in this workbook, you'll find yourself moving more rapidly along the learning curve to join the growing ranks of PL/SQL experts.The Oracle PL/SQL Developer's Workbook is a companion to Steven Feuerstein's bestselling Oracle PL/SQL Programming and his other PL/SQL books from O'Reilly. It contains a carefully constructed set of problems and solutions that will test your language skills and help you become a better developer--both with PL/SQL and with other languages. Exercises are provided at three levels: beginner, intermediate, and expert. The workbook exercises cover all the major features of PL/SQL, including those new to Oracle8i (e.g., Java and web features, autonomous transactions, and bulk binds).You'll find chapters on:
- Basic language elements--variables, naming, loops, conditional and sequential control, exception handling, and records.
- Data structures--index-by tables, nested tables, variables arrays (VARRAYs), and object technology.
- Database interaction--cursors, DML and transaction management, cursor variables, and native dynamic SQL
- Program construction--procedures, functions, blocks, packages, database triggers, and calling PL/SQL functions in SQL.
- Built-in functionality--the character, date, conversion, numeric, and miscellaneous functions, and the DBMS_SQL, DBMS_PIPE, DBMS_OUTPUT, UTL_FILE, and DBMS_JOB built-in packages.
- Miscellaneous topics--using Java with PL/SQL, external programs, PL/SQL web development, tuning PL/SQL, and PL/SQL for DBAs.
definition of century, but it’s a definition that makes it easier to explain RR’s behavior. If the current year is in the first half of the century (years 0 through 49), then: If you enter a date in the first half of the century (i.e., from 0 through 49), RR returns the current century. If you enter a date in the latter half of the century (i.e., from 50 through 99), RR returns the previous century. On the other hand, if the current year is in the latter half of the century (years 50
and INTO clauses Method 2 No queries; just UPDATEs, INSERTs, MERGEs, or DELETEs, with a fixed number of bind variables EXECUTE IMMEDIATE with a USING clause Method 3 single row queried Queries (SELECT statements) with a fixed numbers of columns and bind variables, retrieving a single row of data EXECUTE IMMEDIATE with USING and INTO clauses Method 3 multiple rows queried Queries (SELECT statements) with a fixed numbers of columns and bind variables, retrieving or more rows of data
different semantic meaning from positional notation. The parameter list of overloaded programs must differ by more than parameter mode Even if a parameter in one version is IN and that same parameter in another version is IN OUT, PL/SQL cannot tell the difference at the point at which the program is called. All of the overloaded programs must be defined within the same PL/SQL scope or block (anonymous block, standalone procedure or function, or package) You cannot define one version in
particular function or procedure in the package. The scope of the package data is therefore not a single program, but rather the package as a whole. In the PL/SQL runtime architecture, package data structures persist (hold their values) for the duration of a session (rather than the duration of execution for a particular program). If package data is declared inside the package body, then that data persists for the session but can be accessed only by elements defined in the package itself
Datatype, The CHAR Datatype, String Subtypes, Specifying String Constants, Using Nonprintable Characters, Concatenating Strings, Dealing with Case, Traditional Searching, Extracting, and Replacing, Padding, Trimming, Regular Expression Searching, Extracting, and Replacing–Working with Empty Strings, Working with Empty Strings, Mixing CHAR and VARCHAR2 Values–Character functions and CHAR arguments, String Function Quick Reference–String Function Quick Reference, The TO_CHAR Function–Passing NLS