skip to content
Covid-19 virus
COVID-19 Resources

Reliable information about the coronavirus (COVID-19) is available from the World Health Organization (current situation, international travel). Numerous and frequently-updated resource results are available from this WorldCat.org search. OCLC’s WebJunction has pulled together information and resources to assist library staff as they consider how to handle coronavirus issues in their communities.

Image provided by: CDC/ Alissa Eckert, MS; Dan Higgins, MAM
Oracle9i : the complete reference Preview this item
ClosePreview this item
Checking...

Oracle9i : the complete reference

Author: Kevin Loney; George Koch; TUSC (Firm)
Publisher: New York : McGraw-Hill/Osborne, ©2002.
Edition/Format:   Print book : EnglishView all editions and formats
Summary:
Annotation

Master all the powerful features of Oracle9i using the exclusive information inside this indispensable resource. Written by best-selling Oracle Press authors Kevin Loney and George Koch, this volume explains how to implement all the components of Oracle9i. This is a must-have reference for all Oracle professionals.

Annotation

Master all the powerful features of Oracle9iusing the exclusive information inside this indispensable resource. Written by best-selling Oracle Press authors Kevin Loney and George Koch, this volume explains how to implement all the components of Oracle9i. This is a must-have reference for all Oracle professionals.  Read more...

Rating:

(not yet rated) 0 with reviews - Be the first.

Subjects
More like this

Find a copy in the library

&AllPage.SpinnerRetrieving; Finding libraries that hold this item...

Details

Material Type: Internet resource
Document Type: Book, Internet Resource
All Authors / Contributors: Kevin Loney; George Koch; TUSC (Firm)
ISBN: 0072225211 9780072225211 0072227079 9780072227079 0072227087 9780072227086
OCLC Number: 50696673
Notes: Includes index.
Description: xxxiii, 1256 pages : illustrations ; 24 cm + 1 CD-ROM (4 3/4 in.)
Contents: Critical Database Concepts --
Sharing Knowledge and Success --
The Dangers in a Relational Database --
The Basic Parts of Speech in SQL --
The Basics of Object-Relational Databases --
Introduction to Web-Enabled Databases --
SQL and SQL*PLUS --
Basic SQL*PLUS Reports and Commands --
Getting Text Information and Changing It --
Playing the Numbers --
Dates: Then, Now, and the Difference --
Conversion and Transformation Functions --
Grouping Things Together --
When One Query Depends upon Another --
Some Complex Possibilities --
Building a Report in SQL*PLUS --
Changing Data: insert, update, merge, and delete --
Advanced Use of Functions and Variables --
DECODE and CASE: if, then, and else in SQL --
Creating, Dropping, and Altering Tables and Views --
By What Authority? --
Changing the Oracle Surroundings --
Using SQL*Loader to Load Data --
Accessing Remote Data --
Using Materialized Views --
Using Oracle Text for Text Searches --
Using External Tables --
Using Flashback Queries --
PL/SQL --
An Introduction to PL/SQL --
Triggers --
Procedures, Functions, and Packages --
Object-Relational Databases --
Implementing Types, Object Views, and Methods --
Collectors (Nested Tables and Varying Arrays) --
Using Large Objects --
Advanced Object-Oriented Concepts --
Java in Oracle --
An Introduction to Java --
JDBC and SQLJ Programming --
Java Stored Procedures --
The Hitchhiker's Guide to the Oracle9i Data Dictionary --
The Hitchhiker's Guide to the Oracle Optimizer --
The Hitchhiker's Guide to Oracle9iAS. The Hitchhiker's Guide to Database Administration --
The Hitchhiker's Guide to XML in Oracle.
Other Titles: Oracle 9i :
Responsibility: Kevin Loney, George Koch, and the experts at TUSC.
More information:

Abstract:

Provides coverage of topics core to the 9i release including functions and commands, the Virtual Private Database (VPD), and Flashback Queries. This book includes chapters about using other products  Read more...

Reviews

User-contributed reviews
Retrieving GoodReads reviews...
Retrieving DOGObooks reviews...

Tags

Be the first.
Confirm this request

You may have already requested this item. Please select Ok if you would like to proceed with this request anyway.

Linked Data


\n\n

Primary Entity<\/h3>\n
<http:\/\/www.worldcat.org\/oclc\/50696673<\/a>> # Oracle9i : the complete reference<\/span>\n\u00A0\u00A0\u00A0\u00A0a \nschema:Book<\/a>, schema:CreativeWork<\/a> ;\u00A0\u00A0\u00A0\nlibrary:oclcnum<\/a> \"50696673<\/span>\" ;\u00A0\u00A0\u00A0\nlibrary:placeOfPublication<\/a> <http:\/\/id.loc.gov\/vocabulary\/countries\/nyu<\/a>> ;\u00A0\u00A0\u00A0\nlibrary:placeOfPublication<\/a> <http:\/\/dbpedia.org\/resource\/New_York_City<\/a>> ; # New York<\/span>\n\u00A0\u00A0\u00A0\nschema:about<\/a> <http:\/\/experiment.worldcat.org\/entity\/work\/data\/838779999#CreativeWork\/oracle_computer_file<\/a>> ; # Oracle (Computer file)<\/span>\n\u00A0\u00A0\u00A0\nschema:about<\/a> <http:\/\/experiment.worldcat.org\/entity\/work\/data\/838779999#Topic\/bases_de_donnees<\/a>> ; # Bases de donn\u00E9es<\/span>\n\u00A0\u00A0\u00A0\nschema:about<\/a> <http:\/\/id.worldcat.org\/fast\/1093575<\/a>> ; # Relational databases<\/span>\n\u00A0\u00A0\u00A0\nschema:about<\/a> <http:\/\/experiment.worldcat.org\/entity\/work\/data\/838779999#Topic\/oracle_9i<\/a>> ; # ORACLE 9i<\/span>\n\u00A0\u00A0\u00A0\nschema:about<\/a> <http:\/\/dewey.info\/class\/005.7585\/e22\/<\/a>> ;\u00A0\u00A0\u00A0\nschema:about<\/a> <http:\/\/id.worldcat.org\/fast\/1363816<\/a>> ; # Oracle (Computer file)<\/span>\n\u00A0\u00A0\u00A0\nschema:about<\/a> <http:\/\/experiment.worldcat.org\/entity\/work\/data\/838779999#Topic\/informatique<\/a>> ; # Informatique<\/span>\n\u00A0\u00A0\u00A0\nschema:alternateName<\/a> \"Oracle 9i :<\/span>\" ;\u00A0\u00A0\u00A0\nschema:bookFormat<\/a> bgn:PrintBook<\/a> ;\u00A0\u00A0\u00A0\nschema:contributor<\/a> <http:\/\/viaf.org\/viaf\/136238135<\/a>> ; # TUSC (Firm)<\/span>\n\u00A0\u00A0\u00A0\nschema:contributor<\/a> <http:\/\/viaf.org\/viaf\/37098913<\/a>> ; # George Koch<\/span>\n\u00A0\u00A0\u00A0\nschema:copyrightYear<\/a> \"2002<\/span>\" ;\u00A0\u00A0\u00A0\nschema:creator<\/a> <http:\/\/viaf.org\/viaf\/87972200<\/a>> ; # Kevin Loney<\/span>\n\u00A0\u00A0\u00A0\nschema:datePublished<\/a> \"2002<\/span>\" ;\u00A0\u00A0\u00A0\nschema:description<\/a> \"Annotation<\/span>\"@en<\/a> ;\u00A0\u00A0\u00A0\nschema:exampleOfWork<\/a> <http:\/\/worldcat.org\/entity\/work\/id\/838779999<\/a>> ;\u00A0\u00A0\u00A0\nschema:inLanguage<\/a> \"en<\/span>\" ;\u00A0\u00A0\u00A0\nschema:name<\/a> \"Oracle9i : the complete reference<\/span>\"@en<\/a> ;\u00A0\u00A0\u00A0\nschema:productID<\/a> \"50696673<\/span>\" ;\u00A0\u00A0\u00A0\nschema:publication<\/a> <http:\/\/www.worldcat.org\/title\/-\/oclc\/50696673#PublicationEvent\/new_york_mcgraw_hill_osborne_2002<\/a>> ;\u00A0\u00A0\u00A0\nschema:publisher<\/a> <http:\/\/experiment.worldcat.org\/entity\/work\/data\/838779999#Agent\/mcgraw_hill_osborne<\/a>> ; # McGraw-Hill\/Osborne<\/span>\n\u00A0\u00A0\u00A0\nschema:url<\/a> <http:\/\/catdir.loc.gov\/catdir\/toc\/mh031\/2003270453.html<\/a>> ;\u00A0\u00A0\u00A0\nschema:workExample<\/a> <http:\/\/worldcat.org\/isbn\/9780072227079<\/a>> ;\u00A0\u00A0\u00A0\nschema:workExample<\/a> <http:\/\/worldcat.org\/isbn\/9780072227086<\/a>> ;\u00A0\u00A0\u00A0\nschema:workExample<\/a> <http:\/\/worldcat.org\/isbn\/9780072225211<\/a>> ;\u00A0\u00A0\u00A0\numbel:isLike<\/a> <http:\/\/bnb.data.bl.uk\/id\/resource\/GBA2W6581<\/a>> ;\u00A0\u00A0\u00A0\nwdrs:describedby<\/a> <http:\/\/www.worldcat.org\/title\/-\/oclc\/50696673<\/a>> ;\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n\n

Related Entities<\/h3>\n
<http:\/\/dbpedia.org\/resource\/New_York_City<\/a>> # New York<\/span>\n\u00A0\u00A0\u00A0\u00A0a \nschema:Place<\/a> ;\u00A0\u00A0\u00A0\nschema:name<\/a> \"New York<\/span>\" ;\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n
<http:\/\/dewey.info\/class\/005.7585\/e22\/<\/a>>\u00A0\u00A0\u00A0\u00A0a \nschema:Intangible<\/a> ;\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n
<http:\/\/experiment.worldcat.org\/entity\/work\/data\/838779999#Agent\/mcgraw_hill_osborne<\/a>> # McGraw-Hill\/Osborne<\/span>\n\u00A0\u00A0\u00A0\u00A0a \nbgn:Agent<\/a> ;\u00A0\u00A0\u00A0\nschema:name<\/a> \"McGraw-Hill\/Osborne<\/span>\" ;\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n
<http:\/\/experiment.worldcat.org\/entity\/work\/data\/838779999#CreativeWork\/oracle_computer_file<\/a>> # Oracle (Computer file)<\/span>\n\u00A0\u00A0\u00A0\u00A0a \nschema:CreativeWork<\/a> ;\u00A0\u00A0\u00A0\nschema:name<\/a> \"Oracle (Computer file)<\/span>\" ;\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n
<http:\/\/experiment.worldcat.org\/entity\/work\/data\/838779999#Topic\/bases_de_donnees<\/a>> # Bases de donn\u00E9es<\/span>\n\u00A0\u00A0\u00A0\u00A0a \nschema:Intangible<\/a> ;\u00A0\u00A0\u00A0\nschema:name<\/a> \"Bases de donn\u00E9es<\/span>\"@en<\/a> ;\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n
<http:\/\/experiment.worldcat.org\/entity\/work\/data\/838779999#Topic\/informatique<\/a>> # Informatique<\/span>\n\u00A0\u00A0\u00A0\u00A0a \nschema:Intangible<\/a> ;\u00A0\u00A0\u00A0\nschema:name<\/a> \"Informatique<\/span>\"@en<\/a> ;\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n
<http:\/\/experiment.worldcat.org\/entity\/work\/data\/838779999#Topic\/oracle_9i<\/a>> # ORACLE 9i<\/span>\n\u00A0\u00A0\u00A0\u00A0a \nschema:Intangible<\/a> ;\u00A0\u00A0\u00A0\nschema:name<\/a> \"ORACLE 9i<\/span>\"@en<\/a> ;\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n
<http:\/\/id.loc.gov\/vocabulary\/countries\/nyu<\/a>>\u00A0\u00A0\u00A0\u00A0a \nschema:Place<\/a> ;\u00A0\u00A0\u00A0\ndcterms:identifier<\/a> \"nyu<\/span>\" ;\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n
<http:\/\/id.worldcat.org\/fast\/1093575<\/a>> # Relational databases<\/span>\n\u00A0\u00A0\u00A0\u00A0a \nschema:Intangible<\/a> ;\u00A0\u00A0\u00A0\nschema:name<\/a> \"Relational databases<\/span>\"@en<\/a> ;\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n
<http:\/\/id.worldcat.org\/fast\/1363816<\/a>> # Oracle (Computer file)<\/span>\n\u00A0\u00A0\u00A0\u00A0a \nschema:CreativeWork<\/a> ;\u00A0\u00A0\u00A0\nschema:name<\/a> \"Oracle (Computer file)<\/span>\" ;\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n
<http:\/\/viaf.org\/viaf\/136238135<\/a>> # TUSC (Firm)<\/span>\n\u00A0\u00A0\u00A0\u00A0a \nschema:Organization<\/a> ;\u00A0\u00A0\u00A0\nschema:name<\/a> \"TUSC (Firm)<\/span>\" ;\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n
<http:\/\/viaf.org\/viaf\/37098913<\/a>> # George Koch<\/span>\n\u00A0\u00A0\u00A0\u00A0a \nschema:Person<\/a> ;\u00A0\u00A0\u00A0\nschema:familyName<\/a> \"Koch<\/span>\" ;\u00A0\u00A0\u00A0\nschema:givenName<\/a> \"George<\/span>\" ;\u00A0\u00A0\u00A0\nschema:name<\/a> \"George Koch<\/span>\" ;\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n
<http:\/\/viaf.org\/viaf\/87972200<\/a>> # Kevin Loney<\/span>\n\u00A0\u00A0\u00A0\u00A0a \nschema:Person<\/a> ;\u00A0\u00A0\u00A0\nschema:familyName<\/a> \"Loney<\/span>\" ;\u00A0\u00A0\u00A0\nschema:givenName<\/a> \"Kevin<\/span>\" ;\u00A0\u00A0\u00A0\nschema:name<\/a> \"Kevin Loney<\/span>\" ;\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n
<http:\/\/worldcat.org\/isbn\/9780072225211<\/a>>\u00A0\u00A0\u00A0\u00A0a \nschema:ProductModel<\/a> ;\u00A0\u00A0\u00A0\nschema:isbn<\/a> \"0072225211<\/span>\" ;\u00A0\u00A0\u00A0\nschema:isbn<\/a> \"9780072225211<\/span>\" ;\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n
<http:\/\/worldcat.org\/isbn\/9780072227079<\/a>>\u00A0\u00A0\u00A0\u00A0a \nschema:ProductModel<\/a> ;\u00A0\u00A0\u00A0\nschema:isbn<\/a> \"0072227079<\/span>\" ;\u00A0\u00A0\u00A0\nschema:isbn<\/a> \"9780072227079<\/span>\" ;\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n
<http:\/\/worldcat.org\/isbn\/9780072227086<\/a>>\u00A0\u00A0\u00A0\u00A0a \nschema:ProductModel<\/a> ;\u00A0\u00A0\u00A0\nschema:isbn<\/a> \"0072227087<\/span>\" ;\u00A0\u00A0\u00A0\nschema:isbn<\/a> \"9780072227086<\/span>\" ;\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n
<http:\/\/www.worldcat.org\/title\/-\/oclc\/50696673<\/a>>\u00A0\u00A0\u00A0\u00A0a \ngenont:InformationResource<\/a>, genont:ContentTypeGenericResource<\/a> ;\u00A0\u00A0\u00A0\nschema:about<\/a> <http:\/\/www.worldcat.org\/oclc\/50696673<\/a>> ; # Oracle9i : the complete reference<\/span>\n\u00A0\u00A0\u00A0\nschema:dateModified<\/a> \"2018-12-15<\/span>\" ;\u00A0\u00A0\u00A0\nvoid:inDataset<\/a> <http:\/\/purl.oclc.org\/dataset\/WorldCat<\/a>> ;\u00A0\u00A0\u00A0\u00A0.\n\n\n<\/div>\n