Learn PL/SQL in 1 Day: Definitive Guide to Learn PL/SQL for Beginners

By Krishna Rungta

PL/SQL is an extension of SQL for the Oracle Database. Learn PL/SQL in 1 Day serves as beginner guide for a crash course in PL/SQL development. The book contains tons of examples that prepare you for real-world development project. This book is considered the best Oracle PL/SQL programming guide by the Oracle community. The books gives clear instructions for executing, tracing, testing, debugging, and managing PL/SQL code. Here is what you will learn Chapter 1: What Is PL/SQL? Introduction & Architecture Chapter 2: SQL Vs PL/SQL Vs T-SQL: Key Differences Chapter 3: PL/ SQL Block: STRUCTURE, Syntax, ANONYMOUS Example Chapter 4: PL/SQL First Program: Hello World Example Chapter 5: Oracle PL/SQL Data Types: Character, Number, Boolean, Date, LOB Chapter 6: Oracle PL/SQL Variable Identifiers Tutorial with Examples Chapter 7: Oracle PL/SQL Collections: Varrays, Nested & Index by Tables Chapter 8: Oracle PL/SQL Records Type with Examples Chapter 9: Oracle PL/SQL IF THEN ELSE Statement: ELSIF, NESTED-IF Chapter 10: Oracle PL/SQL: CASE Statement with Examples Chapter 11: Oracle PL/SQL LOOP with Example Chapter 12: Oracle PL/SQL FOR LOOP with Example Chapter 13: Oracle PL/SQL WHILE LOOP with Example Chapter 14: Oracle PL/SQL Stored Procedure & Functions with Examples Chapter 15: Oracle PL/SQL Exception Handling: Examples to Raise User-defined Exception Chapter 16: Oracle PL/SQL Insert, Update, Delete & Select Into [Example] Chapter 17: Oracle PL/SQL Cursor: Implicit, Explicit, Cursor FOR Loop [Example] Chapter 18: Oracle PL/SQL BULK COLLECT: FORALL Example Chapter 19: Autonomous Transaction in Oracle PL/SQL: Commit, Rollback Chapter 20: Oracle PL/SQL Package: Type, Specification, Body [Example] Chapter 21: Oracle PL/SQL Trigger Tutorial: Instead of, Compound [Example] Chapter 22: Oracle PL/SQL Object Types Tutorial with EXAMPLES Chapter 23: Oracle PL/SQL Dynamic SQL Tutorial: Execute Immediate & DBMS_SQL Chapter 24: Nested Blocks & Variable Scope in Oracle PL/SQL Tutorial [Example]

• Format: Paperback
• Language: English
• ISBN: 152125592X
• ISBN13: 9781521255926
• Release Date: May 2017
• Publisher: Independently published
• Length: 221 Pages
• Weight: 1.44 lbs.
• Dimensions: 11.0" x 0.5" x 8.5"