What do you think?
Rate this book
Learn PL/SQL in 1 Day: Definitive Guide to Learn PL/SQL for Beginners
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 Key Differences Chapter 3: PL/ SQL STRUCTURE, Syntax, ANONYMOUS Example Chapter 4: PL/SQL First Hello World Example Chapter 5: Oracle PL/SQL Data Character, Number, Boolean, Date, LOB Chapter 6: Oracle PL/SQL Variable Identifiers Tutorial with Examples Chapter 7: Oracle PL/SQL Varrays, Nested & Index by Tables Chapter 8: Oracle PL/SQL Records Type with Examples Chapter 9: Oracle PL/SQL IF THEN ELSE ELSIF, NESTED-IF Chapter 10: Oracle PL/ 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 Examples to Raise User-defined Exception Chapter 16: Oracle PL/SQL Insert, Update, Delete & Select Into [Example] Chapter 17: Oracle PL/SQL Implicit, Explicit, Cursor FOR Loop [Example] Chapter 18: Oracle PL/SQL BULK FORALL Example Chapter 19: Autonomous Transaction in Oracle PL/ Commit, Rollback Chapter 20: Oracle PL/SQL Type, Specification, Body [Example] Chapter 21: Oracle PL/SQL Trigger Instead of, Compound [Example] Chapter 22: Oracle PL/SQL Object Types Tutorial with EXAMPLES Chapter 23: Oracle PL/SQL Dynamic SQL Execute Immediate & DBMS_SQL Chapter 24: Nested Blocks & Variable Scope in Oracle PL/SQL Tutorial [Example]
Chapter 1: What Is PL/SQL? Introduction & Architecture
Chapter 2: SQL Vs PL/SQL Vs Key Differences Chapter 3: PL/ SQL STRUCTURE, Syntax, ANONYMOUS Example Chapter 4: PL/SQL First Hello World Example Chapter 5: Oracle PL/SQL Data Character, Number, Boolean, Date, LOB Chapter 6: Oracle PL/SQL Variable Identifiers Tutorial with Examples Chapter 7: Oracle PL/SQL Varrays, Nested & Index by Tables Chapter 8: Oracle PL/SQL Records Type with Examples Chapter 9: Oracle PL/SQL IF THEN ELSE ELSIF, NESTED-IF Chapter 10: Oracle PL/ 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 Examples to Raise User-defined Exception Chapter 16: Oracle PL/SQL Insert, Update, Delete & Select Into [Example] Chapter 17: Oracle PL/SQL Implicit, Explicit, Cursor FOR Loop [Example] Chapter 18: Oracle PL/SQL BULK FORALL Example Chapter 19: Autonomous Transaction in Oracle PL/ Commit, Rollback Chapter 20: Oracle PL/SQL Type, Specification, Body [Example] Chapter 21: Oracle PL/SQL Trigger Instead of, Compound [Example] Chapter 22: Oracle PL/SQL Object Types Tutorial with EXAMPLES Chapter 23: Oracle PL/SQL Dynamic SQL Execute Immediate & DBMS_SQL Chapter 24: Nested Blocks & Variable Scope in Oracle PL/SQL Tutorial [Example]
223 pages, Kindle Edition
Published November 23, 2016
27 people are currently reading
27 people want to read
Ratings & Reviews
Friends & Following
Create a free account to discover what your friends think of this book!
Community Reviews
Displaying 1 of 1 review
May 13, 2018
Yeah it's all right. Says it right in the title.
Read this in a few hours because I skipped all of my classes in PL/SQL and I have an assignment due. Gives me enough knowledge to know what I don't know and start my googling.
Recommended for terrible students like me.
Read this in a few hours because I skipped all of my classes in PL/SQL and I have an assignment due. Gives me enough knowledge to know what I don't know and start my googling.
Recommended for terrible students like me.
Displaying 1 of 1 review