- Copyright
- Preface
- About the Authors
- Acknowledgments
- We Want to Hear from You!
- Introduction
- Getting Started with Oracle Database 10g
- Exploring Oracle Database 10g Architecture
- Installing Oracle Database 10g
- Installation Decisions
- Prerequisites
- Installing 10g on UNIX/Linux
- Oracle Database 10g DBCA Overview
- Installing 10g on Windows
- Companion CD Installation and Patches (All Platforms)
- Installation Checklists
- Database and Binary Cloning
- Using Enterprise Manager for Cloning
- Migrating a Database from 8i or 9i
- Overview of Database Upgrade Assistant
- Applying Patches to Database Installations
- Uninstalling from a Failed Install
- Summary
- Customizing Installation Options
- Setting Up Automatic Storage Management
- Quick Wins Using Oracle Database 10g
- Tuning Oracle Database 10g
- Scaling and Availability with Oracle Database 10g
- Utilizing Oracle Database 10g Real Applications Clusters
- Oracle 10g RAC Overview
- Cluster Ready Services
- Service Workload Management
- 10g RAC Installation and Migration Enhancements
- 10g RAC Manageability Enhancements
- Automatic Storage Management for Cluster Management
- Third-Party Cluster Management Support
- Limited Rolling Upgrade with OPATCH
- 10g RAC Tips for Better Use
- Advanced RAC Features in Oracle Database 10g Release 2
- Summary
- Utilizing 10g Physical and Logical Standby with Data Guard
- Effectively Using Flashback Technologies
- Leveraging Grid Technology Features
- Utilizing Oracle Database 10g Real Applications Clusters
- Using Oracle Database 10g Utilities and Other Advanced Features
- Maximizing Data Movement with Oracle Data Pump
- Using 10g SQL*Plus and iSQL*Plus
- Making the Most of Oracle Database 10g
- A Collection of Useful Features
- DML/DDL Features
- Network Features
- Security Features
- Resource Manager and Scheduler
- New Database Initialization Parameters
- Oracle Streams Enhancements
- MetaLink Integration with Oracle Database 10g
- Oracle Database 10g EM Patch Cache
- Oracle Applications 11i with Oracle Database 10g
- Summary
- Index
Summary
This chapter reviewed the latest features for Oracle Database 10g SQL*Plus and iSQL*Plus as well as the new features introduced with Oracle 10g Release 2. These new features and enhancements add greater manageability and flexibility to the SQL environment by adding new DEFINE variables as well as the ability to append to existing SPOOL files.
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.