Oracle Database 12c Hands-On SQL and PL/SQL

This book teaches the basics of the Oracle database, from a beginner's perspective to advanced concepts, using a hands-on approach. Each concept is explained with practical examples and code for clear and precise understanding of the topic. Using a practical approach, this new edition covers the detailed introspection of pluggable databases and explains practically the various new features incorporated in the new 12c version. It also explains how to retrieve, add, update and delete data in the Oracle database using SQL, SQL*PLUS and PL/SQL. In the process, it discusses the various data types and built-in functions of Oracle, as well as the sorting of records and the table operations. The text also includes coverage of advanced queries using special operators, Oracle security, indexing, and stored functions and procedures. The book is suitable for undergraduate engineering students of computer science and information technology, and students of computer applications. It can also be used as a reference by professionals pursuing short-term courses covering the Oracle database and students of Oracle certified courses.