A1960940194_21498_31_2017_OracleWorkshop3.pdf

Documents

280 pages
106 views

Please download to get full document.

View again

of 280
All materials on our website are shared by users. If you have any questions about copyright issues, please report us to resolve them. We are always happy to assist you.
Share
Description
Oracle Database 12c: SQL Workshop II Student Guide - Volume I D80194GC10 Edition 1.0 August 2013 D83185 Dimpi Rani Sarmah This document contains proprietary information and is protected by copyright and other intellectual property laws. You may copy and print this document solely for your own use in an Oracle training course. The document may not be modified or al
Transcript
  Oracle Database 12 c : SQL Workshop II Student Guide -Volume I D80194GC10Edition 1.0 August 2013D83185   This document contains proprietary information and is protected by copyright and other intellectual property laws. You may copy and print this document solely for your own use in an Oracle training course. The document may not be modified or altered in any way. Except where your use constitutes fair use under copyright law, you may not use, share, download, upload, copy, print, display, perform, reproduce, publish, license, post, transmit, or distribute this document in whole or in part without the express authorization of Oracle.  The information contained in this document is subject to change without notice. If you find any problems in the document, please report them in writing to: Oracle University, 500 Oracle Parkway, Redwood Shores, California 94065 USA. This document is not warranted to be error-free. If this documentation is delivered to the United States Government or anyone using the documentation on behalf of the United States Government, the following notice is applicable: U.S. GOVERNMENT RIGHTS  The U.S. Government’s rights to use, modify, reproduce, release, perform, display, or disclose these training materials are restricted by the terms of the applicable Oracle license agreement and/or the applicable U.S. Government contract. Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners. Dimpi Rani Sarmah Nancy Greenberg Swarnapriya Shridhar Bryan Roberts, Laszlo Czinkoczki KimSeong Loh Brent Dayley  Jim Spiller Christopher Wensley Maheshwari Krishnamurthy Daniel Milne Michael Almeida Diganta Choudhury Anjulaponni Azhagulekshmi Subbiahpillai Manish Pawar Clair Bennett  Yanti Chang  Joel Goodman Gerlinde Frenzen Sujatha Nagendra    iii Contents 1 Introduction Lesson Objectives 1-2 Lesson Agenda 1-3 Course Objectives 1-4 Course Prerequisites 1-5 Course Agenda 1-6 Lesson Agenda 1-7  Tables Used in This Course 1-8 Appendixes and Practices Used in This Course 1-10 Development Environments 1-11 Lesson Agenda 1-12 Review of Restricting Data 1-13 Review of Sorting Data 1-14 Review of SQL Functions 1-15 Review of Single-Row Functions 1-16 Review of Types of Group Functions 1-17 Review of Using Subqueries 1-18 Review of Managing Tables Using DML Statements 1-20 Lesson Agenda 1-22 Oracle Database SQL Documentation 1-23 Additional Resources 1-24 Summary 1-25 Practice 1: Overview 1-26 2 Introduction to Data Dictionary Views Objectives 2-2 Lesson Agenda 2-3 Data Dictionary 2-4 Data Dictionary Structure 2-5 How to Use the Dictionary Views 2-7 USER_OBJECTS and ALL_OBJECTS Views 2-8 USER_OBJECTS View 2-9 Lesson Agenda 2-10  Table Information 2-11 Column Information 2-12    iv Constraint Information 2-14 USER_CONSTRAINTS: Example 2-15 Querying USER_CONS_COLUMNS 2-16 Lesson Agenda 2-17 Adding Comments to a Table 2-18 Quiz 2-19 Summary 2-20 Practice 2: Overview 2-21 3 Creating Sequences, Synonyms, and Indexes Objectives 3-2 Lesson Agenda 3-3 Database Objects 3-4 -5 Sequences 3-6 CREATE SEQUENCE Statement: Syntax 3-7 Creating a Sequence 3-9 NEXTVAL and CURRVAL Pseudocolumns 3-10 Using a Sequence 3-12 SQL Column defaulting using a Sequence 3-13 Caching Sequence Values 3-14 Modifying a Sequence 3-15 Guidelines for Modifying a Sequence 3-16 Sequence Information 3-17 Lesson Agenda 3-18 Synonyms 3-19 Creating a Synonym for an Object 3-20 Creating and Removing Synonyms 3-21 Synonym Information 3-22 Lesson Agenda 3-23 Indexes 3-24 How Are Indexes Created? 3-25 Creating an Index 3-26 CREATE INDEX with the CREATE TABLE Statement 3-27 Function-Based Indexes 3-29 Creating Multiple Indexes on the Same Set of Columns 3-30 Example of Creating Multiple Indexes on the Same Set Of Columns 3-31 Index Creation Guidelines 3-32 Index Information 3-33 USER_INDEXES: Examples 3-34 Querying USER_IND_COLUMNS 3-35
We Need Your Support
Thank you for visiting our website and your interest in our free products and services. We are nonprofit website to share and download documents. To the running of this website, we need your help to support us.

Thanks to everyone for your continued support.

No, Thanks
SAVE OUR EARTH

We need your sign to support Project to invent "SMART AND CONTROLLABLE REFLECTIVE BALLOONS" to cover the Sun and Save Our Earth.

More details...

Sign Now!

We are very appreciated for your Prompt Action!

x