O'Reilly logo

Oracle® Database 10g Insider Solutions by Richard Stroupe, John Kanagaraj, Arun Kumar R.

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required