Expert PL/SQL Practices: For Oracle Developers and DBAs
512 pages
Publisher: APRESS ACADEMIC; 1 edition (15 Aug 2011)
Language English
ISBN-10: 1430234857
ISBN-13: 978-1430234852
What you’ll learn
Learn when PL/SQL is best used, and when to avoid it
Move data efficiently using bulk SQL operations
Write code that scales through pipelining, parallelism, and profiling
Choose the right PL/SQL cursor type for any given application
Reduce coding errors through sound development practices such as unit-testing
Create and execute SQL and PL/SQL dynamically at runtime