You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. Then for a category with search results, click Select to choose your product and release filters, and then click OK.

For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"

How do I find the documentation for my product or service?

From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:

  • Click the Find a product tab and search for your product or service.
  • Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
  • Apple Safari: Version 6
  • Google Chrome: Version 29 and later
  • Mozilla Firefox: Version 24 and later
  • Microsoft Internet Explorer: Version 9 and later
Results for DELETE


1 to 20 of 2041 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


DML Reference, 10g Release 1 (10.1)

DELETE

name ...The names of one or more objects, separated by spaces or commas. DELETE removes the definitions of … names and the AW argument in the same DELETE command. When you do not use a qualified object name or … OLAP does not warn you when you delete an object that has the same name as an existing object in … another attached workspace.

Recovery Manager Reference, 10g Release 1 (10.1)

DELETE

Examples'SYSDATE-31'; DELETE NOPROMPT EXPIRED BACKUPSET OF TABLESPACE users DEVICE TYPE sbt COMPLETED BEFORE … archived redo logs that are no longer needed: DELETE NOPROMPT OBSOLETE RECOVERY WINDOW OF 7 DAYS … copies (including archived redo logs) that have already been backed up at least twice to tape: DELETE … NOPROMPT BACKUP BACKED

Recovery Manager Reference, 10g Release 1 (10.1)

DELETE

Restrictions and Usage NotesThe target instance must be started. The DELETE command can delete usable backups and copies from … prior incarnations. A maintenance channel is not required when DELETE is used with a file that is … automatic maintenance channel. If you use DELETE on files that are not disk-only, and if you have … have only a

SQL Reference, 10g Release 1 (10.1)

DELETE

Restrictions on the DML_table_expression Clausesubquery of the DML_table_expression_clause. You cannot delete from a view except through INSTEAD OF … DELETE statement will fail unless the SKIP_UNUSABLE_INDEXES initialization parameter has been set to … true. See Also: ALTER SESSION w here_clause Use the where_clause to delete only rows that satisfy … subquery. You can delete

SQL Reference, 10g Release 1 (10.1)

DELETE

DELETEPurpose Use the DELETE statement to remove rows from: An unpartitioned or partitioned table The … materialized view. Additional Topics Prerequisites Syntax Semantics Examples Prerequisites For you to delete … rows from a table, the table must be in your own schema or you must have the DELETE object privilege … on the table. For

Recovery Manager Reference, 10g Release 1 (10.1)

DELETE

DELETESyntax delete::= Text description of delete maintSpec::= Text description of maintSpec

DML Reference, 10g Release 1 (10.1)

DELETE

DELETEThe DELETE command d eletes one or more objects from a workspace. The deletion becomes permanent … when you execute the UPDATE and COMMIT commands. Syntax DELETE  name... [AW  workspace ] Arguments

Recovery Manager Reference, 10g Release 1 (10.1)

DELETE

PurposeTo delete physical backups and copies as well as do the following: Update their repository records … catalog (if you use a catalog) When running RMAN interactively, DELETE displays a list of the files and … example, you back up a log to disk and then use an operating system utility to delete the file. If you do … not run the CROSSCHECK

Recovery Manager Reference, 10g Release 1 (10.1)

DELETE

Keywords and Parameterslisting the files or prompting for confirmation. The DELETE NOPROMPT command still displays each item … as it is deleted. By default, DELETE displays a list of files to be deleted and prompts for … command. If for some reason a backup or copy marked EXPIRED exists when you run the DELETE EXPIRED

DML Reference, 10g Release 1 (10.1)

TRIGGER command

DELETESpecifies that the trigger for the program is a Delete event. A Delete event is a DELETE statement … for the object. Oracle OLAP executes the specified program immediately before a DELETE statement deletes the object.

Recovery Manager Reference, 10g Release 1 (10.1)

DELETE SCRIPT

Keywords and ParametersSyntax Element Description GLOBAL Specifies that the script to delete is a global stored script … script named script_name and delete that script if it exists.) 'script_name' The name of the script … to delete. See Also: "CREATE SCRIPT", "EXECUTE SCRIPT", "REPLACE SCRIPT", and "LIST" for LIST SCRIPT NAMES.

Recovery Manager Reference, 10g Release 1 (10.1)

DELETE SCRIPT

Examplerecovery catalog: rman TARGET / CATALOG rman/cat@catdb RMAN> DELETE SCRIPT b_whole_10; If a local stored

Recovery Manager Reference, 10g Release 1 (10.1)

DELETE SCRIPT

Restrictions and Usage NotesExecute DELETE SCRIPT only at the RMAN prompt. RMAN must be connected to a recovery catalog and … target database, and the catalog database must be open. To delete a local script, you must be connected

User's Guide and Reference, 10g Release 1 (10.1)

DELETE Statement

DELETE StatementThe DELETE statement removes entire rows of data from a specified table or view. For a full … description of the DELETE statement, see Oracle Database SQL Reference. Syntax Description of the … Statement". table_reference A table or view, which must be accessible when you execute the DELETE … statement, and for which you must

Recovery Manager Reference, 10g Release 1 (10.1)

DELETE SCRIPT

PurposeTo delete a local or global stored script from the recovery catalog.

Recovery Manager Reference, 10g Release 1 (10.1)

DELETE SCRIPT

DELETE SCRIPTSyntax deleteScript::= Text description of deleteScript

DML Reference, 10g Release 1 (10.1)

TRIGGER command

DELETE ALLrequired name No No MAINTAIN DELETE ( not ALL) No required name Yes No MAINTAIN DELETE ALL No required … statement is deleting one or more properties, the literal DELETE. ( TEXT data type) When the value of … argument1 is DELETE, the name of the property or the literal ALL. In all other cases, the name of the

DML Reference, 10g Release 1 (10.1)

$AGGREGATE_FROM

DELETE '$AGGREGATE_FROM'Deletes the $AGGREGATE_FROM property. Examples Example 6-2 Using the $AGGREGATE_FROM Property Example 6-22, "Using a CACHE Statement in an Aggregation Specification" uses the following AGGREGATE command to aggregate the data. AGGREGATE sales_by_revenue USING revenue_aggmap FROM units_aggmap You can place a $AGGREGATE_FROM property on the sales_by_revenue variable by issuing the following statements.

DML Reference, 10g Release 1 (10.1)

MAINTAIN

MAINTAIN DELETEThe MAINTAIN command with the DELETE keyword deletes members from non-concat dimensions and … variables are dimensioned. Note: You can also issue a MAINTAIN DELETE statement for a surrogate … error. Syntax The syntax for using the DELETE keyword of the MAINTAIN command to delete members … following separate entries

Administrator's Guide, 10g Release 1 (10.1)

20 General Management of Schema Objects

Using DELETEYou can delete the rows of a table using the DELETE statement. For example, the following statement … deletes all rows from the emp table: DELETE FROM emp; If there are many rows present in a table or … cluster when using the DELETE statement, significant system resources are consumed as the rows are … DELETE