book

Oracle Database 10g The Complete Reference

by Kevin Loney

September 2004

Intermediate to advanced

1392 pages

34h 54m

English

McGraw Hill Computing

Read now

Unlock full access

Databases and InstancesInside the DatabaseChoosing Architectures and Options

Overview of Licensing and Installation Options
Choosing an Upgrade MethodBefore UpgradingUsing the Database Upgrade AssistantPerforming a Manual Direct UpgradeUsing Export and ImportUsing the Data-Copying MethodAfter Upgrading
The Cooperative ApproachEveryone Has “Data”The Familiar Language of OracleSome Common, Everyday ExamplesWhat Are the Risks?The Importance of the New VisionHow to Reduce the ConfusionCapitalization in Names and DataNormalizing NamesGood Design Has a Human TouchUnderstanding the DataToward Object Name NormalizationIntelligent Keys and Column ValuesThe Commandments
StyleCreating the NEWSPAPER TableUsing SQL to Select Data from Tablesselect, from, where, and order byLogic and ValueAnother Use for where: SubqueriesCombining TablesCreating a View
Building a Simple ReportOther FeaturesChecking the SQL*Plus EnvironmentBuilding Blocks
DatatypesWhat Is a String?NotationConcatenation ( || )How to Cut and Paste StringsUsing order by and where with String FunctionsReview
Search StringsREGEXP_SUBSTR
The Three Classes of Number FunctionsNotationSingle-Value FunctionsAggregate FunctionsList FunctionsFinding Rows with MAX or MINPrecedence and ParenthesesReview
Date ArithmeticROUND and TRUNC in Date CalculationsTO_DATE and TO_CHAR FormattingDates in where ClausesDealing with Multiple CenturiesUsing the EXTRACT FunctionUsing the TIMESTAMP Datatypes
Elementary Conversion FunctionsSpecialized Conversion FunctionsTransformation FunctionsReview
The Use of group by and havingViews of GroupsThe Power of Views of GroupsMore Grouping Possibilities
Advanced SubqueriesOuter JoinsNatural and Inner JoinsUNION, INTERSECT, and MINUS
Complex GroupingsUsing Temporary TablesUsing ROLLUP, GROUPING, and CUBEFamily Trees and connect by
insertrollback, commit, and autocommitMultitable InsertsdeleteupdateUsing the merge Command
if, then, elseReplacing Values via DECODEDECODE Within DECODEGreater Than and Less Than in DECODEUsing CASE
Creating a TableDropping TablesAltering TablesCreating a Table from a TableCreating an Index-Organized TableUsing Partitioned TablesCreating a ViewIndexesClustersSequences
Users, Roles, and PrivilegesWhat Users Can GrantGranting Limited Resources
Initial ConfigurationCreate an Application ContextCreate a Logon TriggerCreate a Security PolicyApply the Security Policy to TablesTest VPDHow to Implement Column-Level VPDHow to Disable VPDHow to Use Policy Groups
Tablespaces and the Structure of the DatabasePlanning Your Tablespace Usage
The Control FileStarting the LoadControl File Syntax NotesManaging Data LoadsTuning Data LoadsAdditional Features
Creating a DirectoryData Pump Export OptionsStarting a Data Pump Export JobData Pump Import OptionsStarting a Data Pump Import Job
Database LinksUsing Synonyms for Location TransparencyUsing the User Pseudo-Column in ViewsDynamic Links: Using the SQL*Plus copy CommandConnecting to a Remote Database
FunctionalityRequired System PrivilegesRequired Table PrivilegesRead-Only vs. Updatablecreate materialized view SyntaxUsing Materialized Views to Alter Query Execution PathsUsing DBMS_ADVISORRefreshing Materialized Viewscreate materialized view log SyntaxAltering Materialized Views and LogsDropping Materialized Views and Logs
Adding Text to the DatabaseText Queries and Text IndexesIndex Sets
Accessing the External DataCreating an External TableAltering External TablesLimitations, Benefits, and Potential Uses of External Tables
Time-Based Flashback ExampleSaving the DataSCN-Based Flashback ExampleWhat If the Flashback Query Fails?What SCN Is Associated with Each Row?Flashback Version QueriesPlanning for Flashbacks
The flashback table CommandThe flashback database Command
PL/SQL OverviewDeclarations SectionExecutable Commands SectionException Handling Section
Required System PrivilegesRequired Table PrivilegesTypes of TriggersTrigger SyntaxEnabling and Disabling TriggersReplacing TriggersDropping Triggers
Required System PrivilegesRequired Table PrivilegesProcedures vs. FunctionsProcedures vs. Packagescreate procedure Syntaxcreate function Syntaxcreate package SyntaxViewing Source Code for Procedural ObjectsCompiling Procedures, Functions, and PackagesReplacing Procedures, Functions, and PackagesDropping Procedures, Functions, and Packages
Using EXECUTE IMMEDIATEUsing Bind VariablesUsing DBMS_SQL
Working with Abstract DatatypesImplementing Object ViewsMethods
Varying ArraysNested TablesAdditional Functions for Nested Tables and Varying ArraysManagement Issues for Nested Tables and Varying Arrays
Available DatatypesSpecifying Storage for LOB DataManipulating and Selecting LOB Values
Row Objects vs. Column ObjectsObject Tables and OIDsObject Views with REFsObject PL/SQLObjects in the Database
Java vs. PL/SQL: An OverviewGetting StartedDeclarationsExecutable CommandsClasses
Getting StartedUsing the JDBC Classes
Loading the Class into the DatabaseHow to Access the Class
Preinstallation StepsInstalling RACStarting and Stopping RAC InstancesTransparent Application FailoverAdding Nodes and Instances to the ClusterManaging the Cluster Registry and Services
Hardware and Operating System Configuration IssuesAdding Servers to the GridSharing Data Across the GridManaging the GridLaunching OEM
A Note About NomenclatureNew Views Introduced in Oracle Database 10gNew Columns Introduced in Oracle Database 10gThe Road Maps: DICTIONARY (DICT) and DICT_COLUMNSThings You Select From: Tables (and Columns), Views, Synonyms, and SequencesRecycle Bin—USER_RECYCLEBIN and DBA_RECYCLEBINConstraints and CommentsAbstract Datatypes, ORDBMS-Related Structures, and LOBsDatabase Links and Materialized ViewsTriggers, Procedures, Functions, and PackagesDimensionsSpace Allocation and Usage, Including Partitions and SubpartitionsUsers and PrivilegesRolesAuditingMiscellaneousMonitoring: The V$ Dynamic Performance Tables
New Tuning Features in Oracle Database 10gTuning—Best PracticesGenerating and Reading Explain PlansMajor Operations Within Explain PlansImplementing Stored OutlinesReview
Case Study 1: Waits, Waits, and More WaitsCase Study 2: Application-Killing QueriesCase Study 3: Long-Running Batch Jobs
What Is Oracle Application Server 10g?Communication ServicesContent Management ServicesBusiness Logic ServicesPresentation ServicesBusiness Intelligence ServicesPortal ServicesWeb ServicesDeveloper ToolkitsPersistence Layer ServicesCaching ServicesSystem ServicesDevelopment Tools
Creating a DatabaseStarting and Stopping the DatabaseSizing and Managing Memory AreasAllocating and Managing Space for the ObjectsMonitoring an Undo TablespaceAutomating Storage ManagementSegment Space ManagementTransporting TablespacesPerforming BackupsWhere to Go from Here
Document Type Definitions, Elements, and AttributesXML SchemaUsing XSU to Select, Insert, Update, and Delete XML ValuesUsing XMLTypeOther Features
Ch47fn1

Overview

Get a thorough understanding of Oracle Database 10g from the most comprehensive Oracle database reference on the market, published by Oracle Press. From critical architecture concepts to advanced object-oriented concepts, this powerhouse contains nearly 50 chapters designed to enlighten you. Upgrade from earlier versions, use SQL, SQL Plus, and PL/SQL. Get code examples and access popular documentation PDFs--plus a full electronic copy of the book on the included CD-ROM. Go beyond the basics and learn security, text searches, external tables, using Java in Oracle, and a great deal more.