Oracle PL/SQL programming(5th Edition)

作者：Steven Feuerstein, Bill Pribyl 出版日期：October 1, 2009 出版社：O'Reilly 页数：1226 ISBN：ISBN-10: 0596514468 ISBN-13: 978-0596514464 文件格式：PDF 文件大小：15.06 MB Review If you’re doing database application development in the Oracle environment, you’re going to have to know PL/SQL, the company’s extended query and update language. If you want your programs to exploit the special capabilities of Oracle software, you’ll need to know the language well. That’s where the third edition of Oracle PL/SQL Programming comes into play. It’s an absolutely comprehensive reference (as well as a rather extensive tutorial) on PL/SQL, ideally suited to answering your questions about how to perform some programming tasks and reminding you of the characteristics of functions, triggers, and other elements of the database programmer’s toolkit. The new edition covers calls to Java methods from within PL/SQL programs, autonomous transactions, object type inheritance, and the new Timestamp and XMLType data types. There’s also more information about server internals–the way PL/SQL programs are run–than before, better enabling readers to optimize their code for fast and safe execution. Steven Feuerstein takes care to explain, with prose and example code, the characteristics of PL/SQL elements. In explaining number conversions, for example, he explores Oracle’s different ways of formatting numbers, then details the behavior of the to_number function under different conditions (with and without a specified format model, and with National Language Support information attached). It’s a helpful approach that will have readers using the index to locate places in which Feuerstein mentions language elements of interest. –David Wall Topics covered: How to use Oracle PL/SQL in all its manifestations through Oracle9i. Fundamentals of program structure (loops, cases, exceptions, etc.) and execution get attention, as do data types, transaction management, triggers, and the object-oriented aspects of the language. There’s also coverage of calls to external Java and C programs. –This text refers to the Paperback edition. Product Description This book is the definitive reference on PL/SQL, considered throughout the database community to be the best Oracle programming book available. Like its predecessors, this fifth edition of Oracle PL/SQL Programming covers language fundamentals, advanced coding techniques, and best practices for using Oracle’s powerful procedural language. Thoroughly updated for Oracle Database 11g Release 2, this edition reveals new PL/SQL features and provides extensive code samples, ranging from simple examples to complex and complete applications, in the book and on the companion website. This indispensable reference for both novices and experienced Oracle programmers will help you: Get PL/SQL programs up and running quickly, with clear instructions for executing, tracing, testing, debugging, and managing PL/SQL code Optimize PL/SQL performance with the aid of a brand-new chapter in the fifth edition Explore datatypes, conditional and sequential control statements, loops, exception handling, security features, globalization and localization issues, and the PL/SQL architecture Understand and use new Oracle Database 11g features, including the edition-based redefinition capability, the function result cache, the new CONTINUE statement, fine-grained dependency tracking, sequences in PL/SQL expressions, supertype invocation from subtypes, and enhancements to native compilation, triggers, and dynamic SQL Use new Oracle Database 11g tools and techniques such as PL/Scope, the PL/SQL hierarchical profiler, and the SecureFiles technology for large objects Build modular PL/SQL applications using procedures, functions, triggers, and packages

Beginning Oracle SQL

作者：Lex de Haan, Tim Gorman, Karen Morton, Daniel Fink, Inger Jorgensen 出版日期：December 21, 2009 出版社：Apress 页数：459 ISBN：ISBN-10: 1430271973 ISBN-13: 978-1430271970 文件格式：PDF 文件大小：6.44 MB Beginning Oracle SQL is your introduction to the interactive query tools and specific dialect of SQL used with Oracle Database. The book is a revision of the classic Mastering Oracle SQL and SQL*Plus by Lex de Haan, and has been updated to cover the very latest developments in Oracle’s version of the SQL query language. Written in an easygoing and example-based style, Beginning Oracle SQL is the book that will get you started down the path to successfully writing SQL statements and getting results from Oracle Database. Takes an example-based approach, with clear and authoritative explanations Introduces both SQL and the query tools used to execute SQL statements Shows how to create tables, populate them with data, and then query that data to generate business results What you’ll learn Create database tables and define their relationships Add data to your tables; change and delete that data Write database queries that generate accurate results Avoid common traps and pitfalls in writing SQL queries Take advantage of advanced Oracle SQL features such as support for hierarchical queries, analytic and window functions, flashback to a given point in time, and more Get a handle on Oracle Database’s support for object types in the database Who is this book for? This book is aimed at developers and database administrators who must write SQL statements to execute against an Oracle database. No prior knowledge of SQL is assumed.

校园资源信息网系统安装及使用说明

动态管理学校网页，主要有：学校简介（图片展示）、领导班子（相片显示）、校园新闻、图片新闻、规章制度、德育管理、教学管理、课件管理、试题管理、论文管理、教案管理和学生信息平台。授权用户可以发布校园信息和图片新闻立即在网页上浏览出来。一般用户可以上传和下载课件、试题、教案、论文和软件等等。学生信息平台由系统管理员授权用户管理。主要有学籍管理、成绩录入和统计（按学号、普通总分、标准分进行排序）、毕业生学籍管理和查询、学生德育考核和操行评语、学生奖励处分记录。设置动态查询功能，由用户自行设置三个查询条件进行精确查询和模糊查询。本系统数据文件全部存贮在数据库中，不受服务器读写权限的限制。保护了服务器的安全。