Chip Dawes Reihenfolge der Bücher (Chronologisch)

Here's the book you need to prepare for the Oracle Database 10g Administration I exam, 1Z0-042. This Study Guide was developed to meet the exacting requirements of today's Oracle certification candidates. In addition to the consistent and accessible instructional approach that has earned Sybex the "Best Study Guide" selection in CertCities Readers Choice Awards for two consecutive years, this book You'll also find authoritative coverage of key exam topics, Look to Sybex for the knowledge and skills needed to succeed in today's competitive IT marketplace

This pocket reference offers quick-access information to utilize Oracle Corporation's built-in functions and packages, including those introduced in Oracle8. Oracle's PL/SQL language provides procedural extensions to SQL and a growing array of development tools. Among its most valuable features are built-in functions and packages, which minimize coding efforts. Functions operate on specific data types, returning results that streamline programming. Functions are categorized as follows: - **Character functions** handle character data (e.g., CONCAT, LENGTH, REPLACE). - **Date functions** work with dates (e.g., SYSDATE, LAST_DAY). - **Numeric functions** manage numeric data (e.g., CEIL, POWER). - **LOB functions** deal with large object data (e.g., EMPTY_BLOB, EMPTY_CLOB). - **Conversion functions** perform data type conversions (e.g., TO_CHAR, TO_NUMBER). - **Miscellaneous functions** include GREATEST and UID. Built-in packages, collections of PL/SQL objects, enhance PL/SQL's capabilities. These packages, created by Oracle and stored in the database, are accessible from various programming environments. Notable packages include DBMS_SQL for executing dynamic SQL, DBMS_PIPE for inter-session communication, DBMS_JOB for job scheduling, and DBMS_LOB for handling large objects. The reference illustrates how to call commonly used functions and packages, including RESTRICT REFERENCES pragmas, exceptions, constants, and data struct