This edition also covers more advanced topics, such as Dynamic SQL and code tuning, as well as developments in bulk processing, compound triggers, PL/SQL compiler features and hiding source code.
The author begins with a step-by-step expanded introduction to fundamental PL/SQL concepts before progressing to the writing and testing of PL/SQL code. ORACLE 11G: PL/SQL PROGRAMMING & ORACLE CD, 2E uses Oracle 11g to provide an overview of the PL/SQL programming language from a developer's perspective.
#ORACLE 10G SQL CASTEEL HOW TO#
Learn how to most effectively use PL/SQL programming language with one of the most popular and widely-used software programs in large companies today - Oracle11g. ORACLE 11G: SQL is not simply a study guide it is written for individuals who have just a basic knowledge of databases and can be utilized in a course on this latest implementation of SQL from Oracle. Important Notice: Media content referenced within the product description or the product text may not be available in the ebook version. Readers can trust ORACLE 12C: SQL, 3E to provide the knowledge for Oracle certification testing and the solid foundation for pursuing a career as a successful database administrator or developer. To help readers transition to further studies, appendixes introduce SQL tuning, compare Oracle's SQL syntax with other databases, and overview Oracle connection interface tools: SQL Developer and SQL Plus. ORACLE 12C: SQL, 3E introduces the latest features and enhancements in 12c, from enhanced data types and invisible columns to new CROSS and OUTER APPLY methods for joins. The author then explores data query techniques, such as row filtering, joins, single-row functions, aggregate functions, subqueries, and views, as well as advanced query topics.
This edition initially focuses on creating database objects, including tables, constraints, indexes, sequences, and more. Learners gain a strong understanding of how to use Oracle 12c SQL most effectively as they prepare for the first exam in the Oracle Database Administrator or Oracle Developer Certification Exam paths. Much more than a study guide, this edition helps those who have only a basic knowledge of databases master the latest SQL and Oracle concepts and techniques. Introduce the latest version of the fundamental SQL language used in all relational databases today with Casteel’s ORACLE 12C: SQL, 3E.