| 000 -LEADER | |
|---|---|
| fixed length control field | 07349cam a22004934a 4500 |
| 001 - CONTROL NUMBER | |
| control field | ocm00009188 |
| 003 - CONTROL NUMBER IDENTIFIER | |
| control field | AE-DuAU |
| 005 - DATE AND TIME OF LATEST TRANSACTION | |
| control field | 20241127164400.0 |
| 008 - FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION | |
| fixed length control field | 050916s2002 caua 000 0 eng |
| 010 ## - LIBRARY OF CONGRESS CONTROL NUMBER | |
| LC control number | 2001099188 |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER | |
| International Standard Book Number | 0782140629 : |
| Terms of availability | 49.99 |
| 040 ## - CATALOGING SOURCE | |
| Original cataloging agency | DLC |
| Transcribing agency | DLC |
| Modifying agency | DLC |
| 042 ## - AUTHENTICATION CODE | |
| Authentication code | pcc |
| 050 00 - LIBRARY OF CONGRESS CALL NUMBER | |
| Classification number | QA76.3 |
| Item number | .D34 2002 |
| 069 ## - | |
| -- | 09707115 |
| 090 ## - LOCALLY ASSIGNED LC-TYPE CALL NUMBER (OCLC); LOCAL CALL NUMBER (OCLC) | |
| Classification number (OCLC) (R) ; Classification number, CALL (RLIN) (NR) | QA 76.3 .D34 2002 |
| 090 ## - LOCALLY ASSIGNED LC-TYPE CALL NUMBER (OCLC); LOCAL CALL NUMBER (OCLC) | |
| Classification number (OCLC) (R) ; Classification number, CALL (RLIN) (NR) | QA 76.3 .D34 2002 |
| 100 1# - MAIN ENTRY--PERSONAL NAME | |
| Personal name | Dawes, Chip. |
| 9 (RLIN) | 19558 |
| 245 10 - TITLE STATEMENT | |
| Title | OCA/OCP : |
| Remainder of title | introduction to Oracle9i SQL : study guide / |
| Statement of responsibility, etc | Chip Dawes, Biju Thomas. |
| 250 ## - EDITION STATEMENT | |
| Edition statement | 1st ed. |
| 260 ## - PUBLICATION, DISTRIBUTION, ETC. (IMPRINT) | |
| Place of publication, distribution, etc | San Francisco, CA : |
| Name of publisher, distributor, etc | Sybex, |
| Date of publication, distribution, etc | 2002. |
| 300 ## - PHYSICAL DESCRIPTION | |
| Extent | 539 p. : |
| Other physical details | ill. ; |
| Dimensions | 24 cm. + |
| Accompanying material | 1 CD-ROM (4 3/4 in.) |
| 336 ## - CONTENT TYPE | |
| Source | rdacontent |
| Content Type Term | text |
| Content Type Code | txt |
| 337 ## - MEDIA TYPE | |
| Source | rdamedia |
| Media Type Term | unmediated |
| Media Type Code | n |
| 338 ## - CARRIER TYPE | |
| Source | rdacarrier |
| Carrier Type Term | volume |
| Carrier Type Code | nc |
| 500 ## - GENERAL NOTE | |
| General note | "Exam 1Z0-007"--Cover. |
| 505 0# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | Basic SQL Select Statements -- Oracle Datatypes -- Operators and Literals -- Writing Simple Queries -- Using the Select Statement -- Limiting Rows -- Other Operators -- In and Not In -- Between -- Exists -- Is Null and is Not Null -- Like -- Sorting Rows -- Sorting Nulls -- Using Expressions -- The Case Expression -- SQL * Plus Overview -- SQL * Plus Fundamentals -- Connecting to SQL * Plus -- Using SQL * Plus -- Using Script Files -- Customizing the SQL * Plus Environment -- Producing More Readable Output -- Setting Page and Line Sizes -- Formatting Columns -- Suppressing Duplicate Values -- Adding Headers and Footers -- Clearing Formatting -- Using a Script File to Create a Report -- Performing Summary Operations -- Accepting Values at Runtime -- Using Substitution Variables -- Saving a Variable for a Session -- Using Positional Notation for Variables -- Using the Accept Command -- Using iSQL * Plus -- iSQL * Plus Architecture -- Working with iSQL * Plus -- iSQL * Plus Restrictions -- Single-Row Functions -- Single-Row Function Fundamentals -- Nulls and Single-Row Functions -- Null Value Functions -- Using Single-Row Character Functions -- Character Function Overview -- Character Function Descriptions -- Using Single-Row Numeric Functions -- Numeric Function Overview -- Numeric Function Descriptions -- Using Single-Row Date Functions -- Date Format Conversion -- Date Function Overview -- Date Function Descriptions -- Using Single-Row Conversion Functions -- Conversion Function Overview -- Conversion Function Descriptions -- Using Other Single-Row Functions -- Miscellaneous Function Overview -- Miscellaneous Function Descriptions -- Aggregating Data And Group Functions -- Group Function Fundamentals -- Using Group Functions -- Group Function Overview -- Group Function Descriptions -- Grouping Data with Group By -- Limiting Grouped Data with Having -- Creating Superaggregates with Cube and Rollup -- Nesting Functions -- Joins and Subqueries -- Multiple-Table Queries -- Simple Joins -- Complex Joins -- Multi-Table Joins -- Cartesian Joins -- Outer Joins -- Other Multiple-Table Queries -- Subqueries -- Single-Row Subqueries -- Multiple-Row Subqueries -- Correlated Subqueries -- Scalar Subqueries -- Multiple-Column Subqueries -- Subqueries in Other DML Statements -- Modifying Data -- Using DML Statements -- Inserting Rows into a Table -- Inserting into Multiple Tables -- Updating Rows in a Table -- Merging Rows into a Table -- Deleting Rows from a Table -- Truncating a Table -- Truncate versus Delete -- Truncate versus Drop Table -- Selecting Rows for Update -- Locking a Table -- Deadlocks -- DML Locks in Oracle -- Understanding Transaction Control -- Savepoints and Partial Rollbacks -- Consistency and Transactions -- Enabling Transaction-Level or Statement-Level Consistency -- Specifying a Rollback Segment for a Transaction -- Managing Tables and Constraints -- Database Objects Review -- Built-in Datatypes -- Character Datatypes -- Numeric Datatype -- Date and Time Datatypes -- Binary Datatypes -- Row ID Datatypes -- Creating Tables -- Naming Tables and Columns -- Specifing Default Values for Columns -- Adding Comments -- Creating a Table from Another Table -- Modifying Tables -- Adding Columns -- Modifying Columns -- Dropping Columns -- Dropping Tables -- Renaming Tables -- Managing Constraints -- Creating Constraints -- Not Null Constraint -- Check Constraints -- Unique Constraints -- Primary Key Constraints -- Foreign Key Constraints -- Disabled Constraints -- Dropping Constraints -- Enabling and Disabling Constraints -- Validated Constraints -- Deferring Constraint Checks -- Managing Views -- Creating and Modifying Views -- Using Defined Column Names -- Creating Views with Errors -- Creating Read-Only Views -- Creating Constraints on Views -- Modifying Views -- Dropping a View -- Using Views -- Using Views in Queries -- Inserting, Updating, and Deleting Data through Views -- Using Join Views -- Viewing Allowable DML Operations -- Using Inline Views -- Performing Top-'N' Analysis -- Other Database Objects -- Creating and Managing Sequences -- Creating and Dropping Sequences -- Using Sequences -- Altering Sequences -- Creating and Managing Synonyms -- Creating and Dropping Synonyms -- Resolving Object References -- Creating and Managing Indexes -- How Indexes Work -- Using B-Tree Indexes -- Using Bitmap Indexes -- Calling Stored Programs -- Using Procedures and Functions -- Using Packages -- User Access and Security -- Creating and Modifying User Accounts -- Configuring Account Authentication -- Assigning Attributes to Accounts -- Using Account Licensing Controls -- Creating and Using Roles -- Granting and Revoking Privileges -- Object Privileges -- System Privileges -- Assigning Privileges -- Revoking Privileges -- Viewing Privileges in the Data Dictionary -- Managing User Groups with Profiles -- Enabling Resource Settings -- Creating and Altering Profiles. |
| 520 #0 - SUMMARY, ETC. | |
| Summary, etc | The perfect way to prepare for the Introduction to Oracle9i SQL exam. Contains exam essentials, real-world scenario sidebars, scenario-based questions, and fill-in-the-blank questions. The CD includes flashcards, chapter-by-chapter exams, random-generated question sets, a bonus exam, and an electronic version of the book. |
| 630 00 - SUBJECT ADDED ENTRY--UNIFORM TITLE | |
| Uniform title | Oracle (Computer file) |
| 9 (RLIN) | 71319 |
| 650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM | |
| Topical term or geographic name as entry element | Electronic data processing personnel |
| General subdivision | Certification. |
| 9 (RLIN) | 73894 |
| 650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM | |
| Topical term or geographic name as entry element | Database management |
| General subdivision | Examinations |
| Form subdivision | Study guides. |
| 9 (RLIN) | 73895 |
| 650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM | |
| Topical term or geographic name as entry element | SQL (Computer program language) |
| 9 (RLIN) | 1922 |
| 700 1# - ADDED ENTRY--PERSONAL NAME | |
| Personal name | Thomas, Biju. |
| 9 (RLIN) | 73896 |
| 852 ## - LOCATION/CALL NUMBER | |
| -- | p49.99 |
| -- | 11-16-2003 |
| 852 ## - LOCATION/CALL NUMBER | |
| -- | p49.99 |
| -- | 07-10-2002 |
| 907 ## - LOCAL DATA ELEMENT G, LDG (RLIN) | |
| a | |
| b | 10-02-12 |
| c | 08-06-10 |
| 942 ## - ADDED ENTRY ELEMENTS (KOHA) | |
| Koha item type | Books |
| 998 ## - LOCAL CONTROL INFORMATION (RLIN) | |
| -- | audmc |
| Operator's initials, OID (RLIN) | 11-16-03 |
| Cataloger's initials, CIN (RLIN) | m |
| First Date, FD (RLIN) | a |
| -- | - |
| -- | eng |
| -- | cau |
| -- | 0 |
| 905 ## - LOCAL DATA ELEMENT E, LDE (RLIN) | |
| a | Chip Dawes, OCP, has worked with Oracle databases since 1990. He is a consultant with D&D Technologies and frequently presents at various Oracle User Group conferences |
| 905 ## - LOCAL DATA ELEMENT E, LDE (RLIN) | |
| a | Biju Thomas, OCP, has over seven years of Oracle database management and application development experience. He currently works as a Database Administrator Consultant for Burlington Resources in Fort Worth, TX |
| 935 ## - | |
| -- | PR10321 |
| 945 ## - LOCAL PROCESSING INFORMATION (OCLC) | |
| g | 0 |
| i | 44916 |
| j | 0 |
| l | audmc |
| n | Copy Type:01 - Books |
| o | - |
| p | 183.71 |
| q | - |
| r | - |
| s | - |
| t | 1 |
| u | 0 |
| v | 0 |
| w | 0 |
| x | 0 |
| y | i10189439 |
| z | 08-06-10 |
| Lost status | Source of classification or shelving scheme | Materials specified (bound volume or other part) | Damaged status | Not for loan | Home library | Current library | Shelving location | Date acquired | Cost, normal purchase price | Total Checkouts | Full call number | Barcode | Date last seen | Cost, replacement price | Price effective from | Koha item type |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Library of Congress Classification | Copy Type:01 - Books | American University in Dubai | American University in Dubai | Main Collection | 2010-08-06 | 183.71 | QA 76.3 .D34 2002 | 44916 | 2023-12-01 | 183.71 | 2015-07-25 | Books |