O'Reilly Oracle Sql Programming

Podstrony

[ Pobierz całość w formacie PDF ]
.Therefore, this book does not cover:"948[Appendix A] What's on the Companion Disk?Administration of Oracle databases.While the DBA can use this book to learn how to write thePL/SQL needed to build and maintain databases, this book does not explore all the nuances of theData Definition Language (DDL) of Oracle's SQL."Application and database tuning.I don't cover detailed tuning issues in this book, though the secondedition does add a chapter on PL/SQL tuning.Oracle Performance Tuning by Peter Corrigan andMark Gurry (O'Reilly & Associates, Second Edition, 1997) gives you all the information you needabout tuning your Oracle applications."Oracle tool-specific technologies independent of PL/SQL.This book won't teach you everything youneed to know about such technologies as SQL*Forms and Oracle Forms triggers.Similarly, you won'tfind detailed discussions of repeating frames of Oracle Reports in here.Nevertheless, many of thetechniques offered in this book certainly do apply to the Oracle Developer/2000 environment."Third-party application development software.There are many alternatives to using PL/SQL and thetools supplied by Oracle to build your applications.This book does not address these options, nordoes it attempt to compare PL/SQL to these third-party products."National Language Support in Oracle.This book does not offer comprehensive coverage of Oracle'sNational Language Support (NLS) capabilities for developing applications for multiple languages."Trusted Oracle.Oracle Corporation has developed a special version of its Oracle7 Server forhigh-security environments.This book does not detail the additional datatypes and features availableonly for Trusted Oracle.Objectives of This Book AudienceCopyright (c) 2000 O'Reilly & Associates.All rights reserved.949PrefaceAudienceThis book was designed to be used by anyone who needs to develop Oracle-based applications using thePL/SQL programming language.There are a number of distinct audiences:Role How to Use the BookInformation systems The application development or database administration manager in an Oraclemanager shop needs a thorough grasp of the technology used in the development groups.Familiarity with the technology will help the manager to better understand thechallenges faced by the team members and the ability of that team to solveproblems.These managers will want to pay particular attention to Part 4, for thebig picture of structuring PL/SQL-based applications.One-person information Oracle licenses are frequently sold into small companies or departments where thesystems shop supporting information systems organization consists of little more than a singlemanager and single developer (or perhaps both of those functions rolled into one).These small organizations do not have the time to search through multiplemanuals or sets of training notes to find the solution to their problems.This bookoffers one-stop shopping for these people -- a consolidated reference andsolutions source.Database administrator The DBA in the world of Oracle7 needs to build database triggers and storedprocedures in order to manage business rules at the RDBMS levels and implementdistributed databases.The DBA will use this book to strengthen his or herunderstanding of how to write efficient RDBMS-level objects.This book will alsodiscuss constructing packages of related objects which will reduce the resourcesrequired to maintain these objects.New developer in the Many developers arrive fresh on the Oracle scene through the use of the newOracle Developer/2000 Oracle Developer/2000 tools in the Windows environment.These developers willenvironment be comfortable manipulating the various widgets in the GUI world, but will findPL/SQL to be a strange, new partner for development.This book will quicklybring them up to speed and make them more productive users of OracleDeveloper/2000 software.Experienced Oracle Many thousands of programmers have spent years writing, debugging, anddeveloper maintaining programs written in SQL*Forms, SQL*Reportwriter, SQL*Plus, andSQL*Menu.While their PL/SQL skills have progressed to meet the needs ofspecific applications, most could expand both their PL/SQL knowledge and theirawareness of its subtleties.In addition, as developers move into the OracleDeveloper/2000 generation, PL/SQL plays a significantly more central role; thedeveloper will have to gain new expertise to meet the demands of this change.Consultant Consultants must offer a high level of service and quality to their customers.Thisadded value is measured in productivity and in the application of skills notcurrently held by the client.Consultants should find this book an invaluable aid indeepening their understanding of PL/SQL technology.950[Appendix A] What's on the Companion Disk?Structure of This Book Conventions Used in ThisBookCopyright (c) 2000 O'Reilly & Associates.All rights reserved.951PrefaceConventions Used in This BookThe following conventions are used in this book:Italicis used for file and directory names.Constant widthis used for code examples.Constant width boldIn some code examples, highlights the statements being discussed.Constant width italicIn some code examples, indicates an element (e.g., a filename) that you supply.UPPERCASEIn code examples, indicates PL/SQL keywords.lowercaseIn code examples, indicates user-defined items such as variables, parameters, etc.punctuationIn code examples, enter exactly as shown.indentationIn code examples, helps to show structure but is not required.--In code examples, a double hyphen begins a single-line comment, which extends to the end of a line./* and */In code examples, these characters delimit a multiline comment, which can extend from one line toanother.In code examples and related discussions, a dot qualifies a reference by separating an object namefrom a component name.For example, dot notation is used to select fields in a record and to specifydeclarations within a package.In syntax descriptions, angle brackets enclose the name of a syntactic element.[ ]In syntax descriptions, square brackets enclose optional items [ Pobierz całość w formacie PDF ]

zanotowane.pl

doc.pisz.pl

pdf.pisz.pl

bezglutenowo.pev.pl