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 ...
Get Oracle® Database 10g Insider Solutions now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
