下载  >  数据库  >  Oracle  > Learning Oracle 12c SQL(3rd) 无水印pdf 0分

Learning Oracle 12c SQL(3rd) 无水印pdf 0分 评分

Learning Oracle 12c SQL(3rd) 英文无水印pdf 第3版 pdf使用FoxitReader和PDF-XChangeViewer测试可以打开
ORACLE 12C: SQL Joan casteel s CENGAGE Learning Australia· Brazil· Mexico· Singapore· United Kingdom· United States Copyright 2016 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part Due to electronic rights, some third party content may be suppressed from the e Book and/or e Chapter(s) Editorial review has deemed that any suppressed content does not materially affect the overall learning experience. Cengage Learning reserves the right to remove additional content at any time if subsequent rights restrictions require it This is an electronic version of the print textbook. Due to electronic rights restrictions, some third party content may be suppressed. Editorial review has deemed that any suppressed content does not materially affect the overall learning experience. The publisher reserves the right to remove content from this title at any time if subsequent rights restrictions require it. For valuable information on pricing, previous editionschangestocurrenteditionsandalternateformatspleasevisitwww.cengage.com/higheredtosearchby ISBN#, author, title, or key word for materials in your areas of interest Important Notice: Media content referenced within the product description or the product text may not be available in the eBook version Copyright 2016 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part. Due to electronic rights, some third party content may be suppressed from the e Book and/or e Chapter(s). Editorial review has deemed that any suppressed content does not materially affect the overall learning experience. Cengage Learning reserves the right to remove additional content at any time if subsequent rights restrictions require it CENGAGE Learnin ORACLE 12c: SQL C 2016, 2010 Cengage Learning oan Casteel WCN:02-200-203 Vice President, General manager, Science ALL RIGHTS RESERVED. No part of this work covered by the ath Quantitative business: balraj kalsi copyright herein may be reproduced, transmitted, stored, or used in any Product Director: Joe Sabatino Form or by any means graphic, electronic, or mechanical, including but not Product Manager: Jason Guyler limited to photocopying, recording, scanning, digitizing, taping, Web distribution, information networks, or information storage and retrieval Content Developer Lori Bradshaw, S4 Carlisle systems, except as permitted under Section 107 or 108 of the 1976 United Senior product assistant: Brad Sullender States Copyright Act, without the prior written permission of the publisher Senior Marketing Manager: Eric La Scola Marketing Coordinator: William guiliani For product information and technology assistance, contact us at Cengage Learning Customer Sales Support, 1-800-354-9706 Art and Cover direction Production For permission to use material from this text or product, Management, and Composition submitallrequestsonlineatwww.cengagecom/permissions Lumina datamatics Inc Further permissions questions can be emailed to Intellectual Property permissionrequest@cengage.com Analyst: Christina Ciaramella Project Manager: Kathryn Kucharek Oracle is a registered trademark, and Oracle 12 SQL Developer, and SQL*Plus are trademarks or registered trademarks of Oracle Corporation Manufacturing Planner: Ron Montgomery and/or its affiliates Cover Image: O Chris Clor/Blend Images/Corbis Some of the product names and company names used in this book have been used for identification pul poses only and may be e trademarks or registered trademarks of their respective manufac d selle Information pertaining to Northwest Airlines was used with their express permission. No part of it may be reproduced or used in any form without prior written permission from Cengage Learning Library of Congress Control Number: 2015942548 SBN:978-1-305-25103-8 Cengage learning 20 Channel Center Street Boston MA 02210 USA Cengage Learning is a leading provider of customized learning solutions with employees residing in nearly 40 different countries and sales in more than 125 countries around the world. Find your local representative at www.cengage.com Cengage Learning products are represented in Canada by Nelson education Ltd TolearnmoreaboutCengageLearningSolutionsvisitwww.cengage.com Purchase any of our products at your local college store or at our preferredonlinestorewww.cengagebrain.com Printed in the United states of america Print number: o1 Print Year: 2015 Copyright 2016 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part Due to electronic rights, some third party content may be suppressed from the e Book and/or e Chapter(s) Editorial review has deemed that any suppressed content does not materially affect the overall learning experience. Cengage Learning reserves the right to remove additional content at any time if subsequent rights restrictions require it To Scott, a true teacher-one who never stops learning Copyright 2016 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part Due to electronic rights, some third party content may be suppressed from the e Book and/or e Chapter(s) Editorial review has deemed that any suppressed content does not materially affect the overall learning experience. Cengage Learning reserves the right to remove additional content at any time if subsequent rights restrictions require it BRIEF CONTENTS Preface XIV Chapter Overview of Database Concepts Chapter 2 Basic SQL SELECT Statements 25 Chapter 3 Table creation and Management 57 Chapter 4 Constraints 103 Chapter 5 Data Manipulation and Transaction Control 141 Chapter 6 Additional Database Objects 181 Chapter 7 User Creation and Management 225 Chapter s Restricting rows and Sorting data 255 Chapter 9 Joining data from Multiple tables 295 Chapter 10 Selected single-Row Functions 347 Chapter 11 Group Functions 401 Chapter 12 Subqueries and MERGE Statements 449 Chapter 13 viewes 495 ppendix a tables for the JustLee Books Database 539 Appendix b sql"Plus and sQL Developer Overview 547 Appendix c oracle resources 555 Appendix d sql"loader 557 ppendix E SoL Tuning Topics 561 Appendix f sql in various databases 579 Glossary 583 58 Copyright 2016 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part Due to electronic rights, some third party content may be suppressed from the e Book and/or e Chapter(s) Editorial review has deemed that any suppressed content does not materially affect the overall learning experience. Cengage Learning reserves the right to remove additional content at any time if subsequent rights restrictions require it TABLE OF CONTENTS Preface XIV Chapter 1 Overview of Database Concepts Introduction Database Terminology Database management System Database Design Entity-Relationship(E-R)Model 1223456 Database normalization Relating Tables in the Database Structured Query Language(SQL) 12 Databases Used in This Textbook 13 Basic Assumptions 13 Tables in the justLee books database 14 Topic sequence 16 Software used in This Textbook 16 Chapter summary Review Questions Multiple choice 18 Hands-On Assignments 21 Advanced Challenge 22 Case Study: City Jail Chapter 2 Basic SQL SELECT Statements 25 Introduction 26 Creating the JustLee Books Database 27 SELECT Statement Syntax 30 Selecting All Data in a table Selecting One Column from a Table Selecting Multiple Columns from a Table 34 Operations in the SeleCT Statement 36 USing Column Aliases 36 Using Arithmetic Operations NULLⅤ alues Using diStiNCT and UNIQUE 42 Using Concatenation Chapter Summary Chapter 2 Syntax Summary 49 Copyright 2016 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part Due to electronic rights, some third party content may be suppressed from the e Book and/or e Chapter(s) Editorial review has deemed that any suppressed content does not materially affect the overall learning experience. Cengage Learning reserves the right to remove additional content at any time if subsequent rights restrictions require it Review Questions 50 Multiple choice 51 Hands-On Assignments 54 Advanced Challenge 55 Case Study: City Jail Chapter 3 Table creation and Management 7 Introduction 58 Table design 59 Table creation Defining Columns Viewing a List of Tables: USER_ TABLES Viewing Table Structures: DESCRIBE Table Creation with Subqueries 70 CREATE TABLE.. AS Command 70 Modifying Existing tables 72 ALTER TABLE.. ADD Command 73 ALTER TABLE . MODIFY Command 74 ALTER TABLE. . DROP COLUMN Command 79 ALTER TABLE. SET UNUSEDDROP UNUSED COLUMNS Command Renaming a Table Truncating a Table 85 Deleting a Table 86 hapter Summary Chapter 3 Syntax Summary Review Questions Multiple choice 94 Hands-On assignments 7 Advanced Challenge Case Study: City Jail 98 Chapter 4 Constraints 103 Introduction 104 Creating Constraints 105 Creating Constraints at the Column level 106 Creating Constraints at the Table level 106 Using the PRimary KEY Constraint 107 Using the foreign KEY Constraint 110 Using the UNIQUE Constraint 115 Using the CHECK Constraint 116 Using the NoT nuLL Constraint 119 Including Constraints During Table Creation 121 Adding Multiple Constraints on a Single Column 125 Viewing Constraint Information 126 vi table of contents Copyright 2016 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part Due to electronic rights, some third party content may be suppressed from the e Book and/or e Chapter(s) Editorial review has deemed that any suppressed content does not materially affect the overall learning experience. Cengage Learning reserves the right to remove additional content at any time if subsequent rights restrictions require it Disabling and Dropping constraints 128 USing DISABLE/ENABLE 128 Dropping constraints 129 Chapter Summary 131 Chapter 4 Syntax Summary 131 Review Questions 133 Multiple choice 134 Hands-On assignments 137 Advanced Challenge 139 Case Study: City Jail 139 Chapter 5 Data Manipulation and Transaction Control 141 Introduction 142 Inserting New Rows 143 Using the INSert Command 143 Handling Virtual Columns 150 Handling Single Quotes in an INsert Value 152 Inserting Data from an Existing Table 154 Modifying Existing Rows 156 Using the UPDatE Command USing Substitution Variables 158 Deleting Rows 162 USing Transaction Control Statements 163 comMit and rollbacK Commands 164 SAVEPOINT COmmand 165 USing Table locks 168 LOCK TABLE Command 168 SELECT. FOR UPDATE Command 169 Chapter summary 171 Chapter 5 Syntax Summary 172 Review Questions 173 Multiple choice 173 Hands-On Assignments 176 Advanced Challenge 177 Case Study: City Jail 178 Chapter 6 Additional Database Objects 1S1 Introduction 1S2 Sequences 183 Creating a Sequence 1S4 USing Sequence values 189 Setting and altering Sequence Definitions 192 Altering Sequence Definitions 194 Removing a sequence 196 Use Identity Columns Instead of Sequences for Primary Key columns 197 Table of contents vii Copyright 2016 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part Due to electronic rights, some third party content may be suppressed from the e Book and/or e Chapter(s) Editorial review has deemed that any suppressed content does not materially affect the overall learning experience. Cengage Learning reserves the right to remove additional content at any time if subsequent rights restrictions require it

...展开详情
所需积分/C币:16 上传时间:2017-01-14 资源大小:17.81MB
举报 举报 收藏 收藏
分享 分享
《深入理解Oracle 12c数据库管理 第2版》PDF版本下载.txt

《深入理解Oracle 12c数据库管理 第2版》PDF版本下载

立即下载
Oracle 12c PL/SQL程序设计终极指南

PL/SQL本身涉及的知识点浩瀚、庞杂,初学者根本无法依靠自身能力理清头绪,学习成本极高.本书对知识点进行了体系化的梳理,化繁杂为有序,突出重点,直指核心,循序渐进,尽可能为学习者提供“捷径”,仅仅只是这一点,本书就与同类书拉开了距离.本书以Oracle的最新版本12c为基础,呈现的是最新的PL/SQL技术,这一点也优于已出版的同类书.全书以一个综合性的人力资源项目为驱动,不仅能将各个理论知识点很好地融入实践,而且还能让读者体验完整的项目实操过程, ”精讲多练“也是本书的一个重要特色,确保读者真正能学会。当然,最为重要的还是内容本身,本书首先对PL/SQL的理论基础进行了全面的介绍,其次详细讲

立即下载
精通Oracle Database 12c SQL & PL/SQL编程(第3版) 扫描版 高清完整带书签

学习通过编写SQL语句并构建PL/SQL程序来访问Oracle数据库。《精通Oracle Database 12c SQL & PL/SQL编程(第3版)》完全涵盖了*版本Oracle数据库的功能和技术,指导读者编写SQL语句以检索和修改数据库中的信息、掌握SQL*Plus和SQL Developer、处理数据库对象、编写PL/SQL程序、采用性能优化技术、结合XML以及其他技术。这本Oracle指南包含掌握SQL所需的全部知识。

立即下载
Oracle 12c DBA官方手册pdf

Oracle 12c DBA官方手册pdf 第8版,都是本人自用的资料,带书签。

立即下载
精通Oracle Database 12c SQL & PL_SQL编程(第3版)

[精通Oracle Database 12c SQL & PL_SQL编程(第3版)]978-7-302-36598-3code

立即下载
Oracle12c完全参考手册.zip

Oracle12C完全参考手册(第7板);书中所有SQL脚本集;

立即下载
Oracle 12c 从入门到精通(第二版)

Oracle 12c 从入门到精通(第二版),都是本人自用的资料,带书签。

立即下载
Oracle.Database.12c完全参考手册(第7版) 1317页中文高清完整版PDF

百度网盘下载,大约250MB。 绝非试读版!绝对完整高清,免积分,PDF中没有链接问你支付宝付费才能看完整版。完全免费!放心下!

立即下载
《Oracle Database 12c完全参考手册 第7版》PDF版本下载.txt

《Oracle Database 12c完全参考手册 第7版》PDF版本下载

立即下载
Learning SQL.pdf

Alan Beaulieu编著的全英版《Learning SQL.pdf》,

立即下载
oracle12c数据库中文资料大全

包含oracle12c所有新功能特性中文文档资料,资料内容保存的是各个中文资料的官方链接pdf,是目前收集最全的12c中文资料。

立即下载
Oracle 12c从入门到精通

Oracle 12c从入门到精通,深入浅出的Oracle 数据库的入门简介

立即下载
深入理解Oracle 12c数据库管理_PDF电子书下载 带书签目录 高清完整版.part3

深入理解Oracle 12c数据库管理_PDF电子书下载 带书签目录 高清完整版 共3个压缩包,第一个

立即下载
深入理解Oracle 12c数据库管理_PDF电子书下载 带书签目录

《深入理解Oracle 12c数据库管理》全面覆盖DBA行业知识,深入细致地介绍了Oracle 12c数据库管理工作,并将理论与实践相结合,旨在提供高效运行数据库所需的方方面面的知识,适合各个层次的Oracle数据库应用开发人员或DBA。

立即下载
深入理解Oracle_RAC_12c PDF电子书下载 带书签目录 完整版.zip(2-2)

花钱买的,深入理解Oracle_RAC_12c PDF电子书下载 带书签目录 完整版.zip,之前那个只有5章,共两个包,链接:https://download.csdn.net/download/notbaron/9457128

立即下载