After completing this course, you should be able to do the following: Design PL/SQL packages and program units that execute efficiently Write code to interface with external applications and the operating system Create PL/SQL applications that use collections Write and tune PL/SQL code effectively to maximize performance Implement a virtual private database with fine-grained access control Write code to interface with large objects and use SecureFile LOBs Perform code analysis to find program ambiguities, test, trace, and profile PL/SQL code
Чтобы скачать этот файл зарегистрируйтесь и/или войдите на сайт используя форму сверху.
Apress, 2011. - 490 p. Expert PL/SQL Practices is a book of collected wisdom on PL/SQL programming from some of the best and the brightest in the field. Each chapter is a deep-dive into a specific problem, technology, or feature set that you’ll face as a PL/SQL programmer. Each author has chosen their topic out of the strong belief that what they share can make a positive...
With this book, you will Master standard SQL, as well as the extensions developed by Oracle Corporation for use with the specific features of the Oracle database. Explore PL/SQL (Procedural Language/SQL), which is built on top of SQL and enables you to write programs that contain SQL statements. Use SQL*Plus to execute SQL statements, scripts, and reports; SQL*Plus is a tool...
Oracle, D50317GC20, 3 тома, включая практические (лабораторные) работы и решения. Текст ссылки This Oracle Database 11g Performance Tuning training starts with an unknown database that requires tuning. You'll then learn the steps a DBA performs to identify problem areas, diagnose common problems and fix them. Learn To: Describe Oracle tuning methodology. Use Oracle supplied...
ДиаСофт, 2005. - 560 с.
Эта книга издательства Apress открывает новую серию книг о СУБД Oracle. Авторы книг серии OakTable Press - общепризнанные эксперты по Oracle. Вместе с издательством Apress они создают точные и содержащие множество полезной информации книги, посвященные решению реальных проблем, попирающие общепринятые мнения и побуждающие к исследованиям.
"Oracle PL/SQL...