Oracle PL/SQL programming fundamentals to advanced

"In the fundamentals module, Oracle ACE Director Dan Hotka teaches developers how to work with existing code and create new programs. Along the way, students will learn both conditional and looping syntax and techniques, error handling and error processing, plus how to work with script files, p...

Full description

Bibliographic Details
Main Author: Hotka, Dan
Format: eBook
Language:English
Published: [Place of publication not identified] Prentice Hall 2015
Series:LiveLessons
Subjects:
Online Access:
Collection: O'Reilly - Collection details see MPG.ReNa
LEADER 03041nmm a2200337 u 4500
001 EB001937996
003 EBX01000000000000001100898
005 00000000000000.0
007 cr|||||||||||||||||||||
008 210123 ||| eng
050 4 |a QA76.9.D3 
100 1 |a Hotka, Dan 
245 0 0 |a Oracle PL/SQL programming  |b fundamentals to advanced  |c Dan Hotka 
260 |a [Place of publication not identified]  |b Prentice Hall  |c 2015 
300 |a 1 streaming video file (12 hr., 11 min., 36 sec.)  |b digital, sound, color 
653 |a Oracle (Computer file) / http://id.loc.gov/authorities/names/n91015760 
653 |a Bases de données / Gestion 
653 |a PL/SQL (Langage de programmation) 
653 |a Database management / fast / (OCoLC)fst00888037 
653 |a PL/SQL (Computer program language) / fast / (OCoLC)fst01049863 
653 |a Database management / http://id.loc.gov/authorities/subjects/sh85035848 
653 |a Oracle (Computer file) / fast / (OCoLC)fst01363816 
653 |a PL/SQL (Computer program language) / http://id.loc.gov/authorities/subjects/sh96008008 
041 0 7 |a eng  |2 ISO 639-2 
989 |b OREILLY  |a O'Reilly 
490 0 |a LiveLessons 
500 |a Title from resource description page (viewed September 10, 2015) 
856 4 0 |u https://learning.oreilly.com/videos/~/9780134291482/?ar  |x Verlag  |3 Volltext 
082 0 |a 658 
082 0 |a 000 
520 |a "In the fundamentals module, Oracle ACE Director Dan Hotka teaches developers how to work with existing code and create new programs. Along the way, students will learn both conditional and looping syntax and techniques, error handling and error processing, plus how to work with script files, procedures, functions and packages (a collection of procedures and functions). In the advanced module, Dan demonstrations how to take advantage of better options for performance, gain knowledge about the newer features of the language, as well as actually work with these same features in hands-on lab exercises. The students will learn the latest features of PL/SQL collections, triggers, and a variety of compiler features such as conditional compilation, result_cache/deterministic features for functions, autonomous transactions, optimizing compiler features, and more. Dan covers additional exception processing useful for collections. The advanced lessons include useful extensions to the error processing part with a clever use of database triggers. This advanced lessons also covers a variety of PL/SQL performance tips and the tuning and debugging tools for the PL/SQL programming environment. This LiveLessons course contains hands-on lab exercises throughout, and three common tools are used for demonstration, including SQL*Plus, Toad, and SQL*Developer. Students can use the Oracle PL/SQL development tool of their choice to do the hands-on labs with these lessons. All examples work with Oracle10, Oracle11, and Oracle12 databases, but the concepts and most of the tips apply to any Oracle database."--Resource description page