Oracle Help for the Web

Database Script: DML

Use this page to enter the text of a DML or SQL script.

After entering the script, you can execute it immediately, or save it for later use, or both.

Field Descriptions

Field	Description
Enter	Type in the body of your script. The script can be DML or SQL.
Save	Click to save your script.
Execute	Click to execute your script immediately.
Close	Click to close this wizard and return to the Navigator.

Scripts are stored in the database under a particular schema, and can be run later only under that schema.
Only select/update/insert/delete statements are supported, and only a single such statement is allowed in any one script. Anonymous PL/SQL blocks are also allowed.
DML actions on any other schema are not allowed -- even if you have privileges on that schema.
DDL statements are not supported.
Pagination for a large number of selected rows is not supported.
Batch mode execution is not supported

To locate this page in OracleAS Portal:

On the Portal Builder page, click the Navigator link.
Click the Database Objects tab.
In the Name column, scroll down to the schema in which you want to build the object.
Click the schema's name.
Click Create New...Script.