DMLDDL Features


DML/DDL Features

In SQL*Plus, you can use the DBMS_OUTPUT information from a nested PL/SQL procedure or trigger in a SELECT statement to improve PL/SQL debugging and reporting.

The improved functionality of transparent gateways in Oracle Database 10g allows the use of remote stored functions in database SELECT statements. This will help you to query data and use remote functions stored in a non-Oracle database with SELECT statements. This feature helps to improve the local processing of non-Oracle data and helps the gateway deal with a reduced amount of data processing.

Data Manipulation Language (DML) statements are part of all databases. DML statements query or manipulate the data in schema objects such as tables. In Oracle Database 10g, you can use single-set aggregates in RETURNING clauses of DML statements. This helps to improve the performance in transactions involving many rows of the same table as in batch jobs. Similarly, the new SQL DML Web Services allows the implementation of Web services as a single or group INSERT, UPDATE, and DELETE operation.

In Oracle Database 10g Release 2, DML is supported in the RETURNING clause of JDBC operations. This will increase database query performance by saving on a client-to-database roundtrip access. Also, intra-partition DML is now possible with bitmap indexes.

A DML error-logging table is a new feature in Oracle Database 10g Release 2. It allows bulk DML operations to continue processing even when an error occurs. When a DML error occurs, the statement continues after recording the errors in a DML error-logging table. This helps in the functionality of row-level error handling in bulk data processing. The database user can specify whether or not errors should be logged at the DML statement level. Similarly, the user can control the level of details and maximum error threshold as in SQL*Loader and external tables.



    Oracle Database 10g Insider Solutions
    SUSE LINUX Enterprise Server 9 Administrators Handbook
    ISBN: 672327910
    EAN: 2147483647
    Year: 2006
    Pages: 214

    flylib.com © 2008-2017.
    If you may any questions please contact us: flylib@qtcs.net