forum de la classe 733 du lycée Grandmont est désormais compatible avec l'extension FastNews.kiwi disponible pour votre navigateur. Avec cette extension, vérifiez s'il y a des nouveaux sujets sur ce forum en un clic depuis n'importe quelle page !Cliquez ici pour en savoir plus.
ced5a5f5e9 Security Detailed information on database features used to secure your data against unauthorized access. SQL Language Reference Contains a complete description of Oracle SQL, the language used to manage information in Oracle Database. PDF for offline viewing ePub for iBooks and mobile devices Mobi for Kindle Performance Tuning Guide Describes how to tune the performance of Oracle Database and SQL statements using Oracle performance tools in the command-line interface. PDF for offline viewing ePub for iBooks and mobile devices Mobi for Kindle . Starting chapter 7 onwards there are topics with high applicability like SecureFiles, tuning, caching, profiling and tracing and SQL Injection prevention techniques that should be read by every Oracle PL/SQL developer but are not very well understood and unfortuntely underused by the community. Read More . PDF for offline viewing ePub for iBooks and mobile devices Mobi for Kindle SQL*Plus Quick Reference Contains a complete list of SQL*Plus command syntax. Backup and Recovery Use Recovery Manager (RMAN) or user-managed backup techniques to back up and recover Oracle databases. HASH(0x93831b1c) out of 5 stars Very useful book 7 June 2013 By Abhinav - Published on Amazon.comFormat: Paperback This book covers all the basic concepts of PL/SQL and found it to be very useful for PL/SQL beginners like me, with very little prior exposure.
Table of Contents Chapter 1: Overview of PL/SQL Programming Concepts Introduction to PL/SQL Cursors an overview Exception handling in PL/SQL Creating stored procedures Functions A PL/SQL package Oracle Database 12c enhancements to PL/SQL subprograms Managing database dependencies Reviewing Oracle-supplied packages Oracle SQL Developer Summary Practice exercise Chapter 2: Oracle 12c SQL and PL/SQL New Features Database consolidation and the new Multitenant architecture Oracle 12c SQL and PL/SQL new features The Oracle Database 12c (188.8.131.52) In-Memory option Summary Chapter 3: Designing PL/SQL Code Cursor structures Cursor variables Implicit statement results in Oracle Database 12c Subtypes Summary Practice exercise Chapter 4: Using Collections Introduction to collections Collection types Associative arrays Nested tables Varray Comparing the collection types Oracle 12c enhancements to collections PL/SQL collection methods Summary Practice exercise Chapter 5: Using Advanced Interface Methods Overview of External Procedures Components of external procedure execution flow Executing external C programs from PL/SQL Securing External Procedures with Oracle Database 12c Executing Java programs from PL/SQL Summary Practice exercise Chapter 6: Virtual Private Database Oracle Database Security overview Fine-Grained Access Control Virtual Private Database Virtual Private Database metadata Oracle Database 12c Security enhancements Summary Practice exercise Chapter 7: Oracle SecureFiles Introduction to Large Objects LOB data types in Oracle Oracle SecureFiles Working with LOBs Migrating LONG to LOBs Migrating BasicFiles to SecureFiles Oracle Database 12c enhancements to SecureFiles Summary Practice exercise Chapter 8: Tuning the PL/SQL Code The PL/SQL Compiler Native and interpreted compilation techniques Tuning PL/SQL code Summary Practice exercise Chapter 9: Result Cache Oracle Database 11g Result Cache SQL query Result Cache PL/SQL Function Result Cache OCI Client results cache The DBMSRESULTCACHE package Result cache in Real Application Clusters Summary Practice exercise Chapter 10: Analyzing, Profiling, and Tracing PL/SQL Code A sample PL/SQL program Tracking PL/SQL coding information Determining identifier types and usages The DBMSMETADATA package Tracing PL/SQL programs using DBMSTRACE Profiling PL/SQL code Summary Practice exercise Chapter 11: Safeguarding PL/SQL Code against SQL injection What is SQL injection? Preventing SQL injection attacks Testing the code for SQL injection flaws Summary Practice exercise Chapter 12: Working with Oracle SQL Developer An overview of SQL Developer Getting started with SQL Developer SQL Developer 4.0 and 4.1 New Features Summary Book Details ISBN 139781785284809 Paperback428 pages . Pinterest is using cookies to help give you the best experience we can. PDF for offline viewing ePub for iBooks and mobile devices Mobi for Kindle SQL*Plus Release Notes Contains important information not included in the SQL*Plus User's Guide and Reference. Download As. Was this review helpful to you? Yes No Sending Feedback. Download As. If you are familiar with computers, but unfamiliar with administering Oracle Database, and your computer has four CPUs or fewer, and you do not expect to support more than 500 users, this book is appropriate for you. SQL*Plus is a command-line client used for running SQL statements and compiling PL/SQL code. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.