create table new_features
(
version varchar2(5),
feature varchar2(256)
);
CREATE VIEW beta_features
AS
SELECT regexp_substr(feature,'[0-9\.]+') section,
regexp_replace(feature,'^["o \.0-9]+','') feature from new_features
WHERE version='BETA';
CREATE VIEW final_features
AS
SELECT regexp_substr(feature,'[0-9\.]+') section,
regexp_replace(feature,'^["o \.0-9]+','') feature from new_features
WHERE version='FINAL';
SELECT section,feature
FROM beta_features
WHERE feature NOT IN
(SELECT feature FROM final_features WHERE feature IS NOT null);
SELECT section,feature
FROM final_features
WHERE feature NOT IN
(SELECT feature FROM beta_features WHERE feature IS NOT null);
SQL> SELECT section,feature
2FROM beta_features
3WHERE feature NOT IN
4(SELECT feature FROM final_features WHERE feature IS NOT null);
SECTIONFEATURE
-------- ------------------------------------------------------------------------------------------
1.1.1DB2 Migration
1.1.2Ease-of-Use
1.1.3Fusion Application Support
1.2.2.1Edition-Based Redefinition
1.3.1Enable the Information Grid
1.3.2.4Current Configuration Dropdown Box in Design Center Toolbar
1.4.1.14 Integration of Cluster Verification Utility (CVU) and Oracle Universal Installer (OUI)
1.4.1.27 UCP Integration with Oracle Data Guard
1.5.1General Database
1.5.1.1Flashback Data Archive support for DDLs
1.5.4.3IPv6 Support in Oracle Database
SECTIONFEATURE
-------- ------------------------------------------------------------------------------------------
1.5.5Table Compression
1.5.5.1Hybrid Columnar Compression
1.7Information Integration
1.7.1Oracle Streams
1.7.1.1XStream In
1.7.1.2XStream Out
1.8.1.1Stored Outlines Migration for SQL Plan Management
1.8.2Optimize for Larger Disk Sectors
1.8.3Simplify Performance Features
1.9.2.1Tablespace Master Key Re-Key
1.10.2 Database Control
SECTIONFEATURE
-------- ------------------------------------------------------------------------------------------
1.10.2.1 EMCA Supports New Oracle RAC Configuration for EM
1.10.2.2 SQL Monitoring
1.10.3 Intelligent Infrastructure
1.10.3.1 Automatic Workload Repository (AWR) Support for New Features
1.10.4 Simplified Configuration
1.10.4.5 Zero-Size Unusable Indexes and Index Partitions ***
1.10.5 Storage Management Enhancements for Storage Administrators
1.11.2 Enhanced Spatial Support
1.11.3 Oracle Secure Files
1.11.3.2 SecureFiles Archive Manager
已选择32行。
SQL>
SQL> SELECT section,feature
2FROM final_features
3WHERE feature NOT IN
4(SELECT feature FROM beta_features WHERE feature IS NOT null);
SECTIONFEATURE
-------- ------------------------------------------------------------------------------------------
1.1.2Other General Development Features
1.2.2.1Edition-based Redefinition
1.3.1Improved Analytics
1.3.2Improved Data Loading
1.3.3Improved Partitioning
1.3.4Improved Performance and Scalability
1.3.5.4Current Configuration Dropdown List in Design Center Toolbar
1.4.1.3Integration of Cluster Verification Utility and Oracle Universal Installer
1.4.1.19 Improved Deinstallation Support With Oracle Universal Installer
1.4.1.27 Universal Connection Pool (UCP) Integration with Oracle Data Guard
1.5.1General
SECTIONFEATURE
-------- ------------------------------------------------------------------------------------------
1.5.1.1Flashback Data Archive Support for DDLs
1.7.1.1Stored Outlines Migration to SQL Plan Management
1.8.2.1Tablespace Master Key Rekey
1.9.2Database Management
1.9.2.1EMCA Supports New Oracle RAC Configuration for Enterprise Manager
1.9.2.6Zero-Size Unusable Indexes and Index Partitions
1.9.2.8Compare Period Report
1.9.2.9Compare SQL Tuning Sets
1.9.2.10 Enable Sampling for Active Data Guard
1.9.2.11 Exadata Simulation
1.9.2.12 Global Oracle RAC ASH Report + ADDM Backwards Compatibility
SECTIONFEATURE
-------- ------------------------------------------------------------------------------------------
1.9.2.13 Oracle MTS and Streams Support
1.9.2.15 Synchronization Controls
1.10.2 Enhanced Oracle Spatial Support
1.10.3 Oracle SecureFiles
1.10.3.1 Database File System (DBFS)
已选择27行。
|