

Oracle PL/SQL Training Guide
Ben Forta
SKU: 9788183334518
Rs. 498
FREE PREVIEW
ISBN: 9788183334518
Authors: Ben Forta
Rights: Worldwide
Publishing Date: July 2016
Pages: 271
Weight:
Dimension: 21 X 14 X 1.5 cm
Authors: Ben Forta
Rights: Worldwide
Publishing Date: July 2016
Pages: 271
Weight:
Dimension: 21 X 14 X 1.5 cm
Book Type: Paperback
It offers straightforward, practical answers when you need fast results.
By working through the book’s 26 lessons of 10 minutes or less, you’ll learn what you need to know to take advantage of Oracle’s PL/SQL language.
This handy pocket guide starts with simple data retrieval and moves on to more complex topics, including the use of joins, sub queries, regular expression and full text-based searches, stored procedures, cursors, triggers, table constraints, and much more.
Chapter 1: Understanding SQLÂ
Chapter 2: Getting Started with Oracle and PL/SQLÂ
Chapter 3: Working with Oracle1
Chapter 4: Retrieving DataÂ
Chapter 5: Sorting Retrieved DataÂ
Chapter 6: Filtering DataÂ
Chapter 7: Advanced Data Filtering1
Chapter 8: Using Wildcard FilteringÂ
Chapter 9: Searching Using Regular ExpressionsÂ
Chapter 10: Creating Calculated FieldsÂ
Chapter 11: Using Data Manipulation FunctionsÂ
Chapter 12: Summarizing DataÂ
Chapter 13: Grouping DataÂ
Chapter 14: Working with Sub queriesÂ
Chapter 15: Joining TablesÂ
Chapter 16: Creating Advanced JoinsÂ
Chapter 17: Combining QueriesÂ
Chapter 18: Inserting DataÂ
Chapter 19: Updating and Deleting DataÂ
Chapter 20: Creating and Manipulating TablesÂ
Chapter 21: Using ViewsÂ
Chapter 22: Working with Stored ProceduresÂ
Chapter 23: Using CursorsÂ
Chapter 24: Using TriggersÂ
Chapter 25: Managing Transaction ProcessingÂ
Chapter 26: Managing SecurityÂ
Appendix A: The Example TablesÂ
Appendix C: Oracle PL/SQL Reserved Words and Keywords
Chapter 2: Getting Started with Oracle and PL/SQLÂ
Chapter 3: Working with Oracle1
Chapter 4: Retrieving DataÂ
Chapter 5: Sorting Retrieved DataÂ
Chapter 6: Filtering DataÂ
Chapter 7: Advanced Data Filtering1
Chapter 8: Using Wildcard FilteringÂ
Chapter 9: Searching Using Regular ExpressionsÂ
Chapter 10: Creating Calculated FieldsÂ
Chapter 11: Using Data Manipulation FunctionsÂ
Chapter 12: Summarizing DataÂ
Chapter 13: Grouping DataÂ
Chapter 14: Working with Sub queriesÂ
Chapter 15: Joining TablesÂ
Chapter 16: Creating Advanced JoinsÂ
Chapter 17: Combining QueriesÂ
Chapter 18: Inserting DataÂ
Chapter 19: Updating and Deleting DataÂ
Chapter 20: Creating and Manipulating TablesÂ
Chapter 21: Using ViewsÂ
Chapter 22: Working with Stored ProceduresÂ
Chapter 23: Using CursorsÂ
Chapter 24: Using TriggersÂ
Chapter 25: Managing Transaction ProcessingÂ
Chapter 26: Managing SecurityÂ
Appendix A: The Example TablesÂ
Appendix C: Oracle PL/SQL Reserved Words and Keywords