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 DROP


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


Supplied Java Packages Reference, 9i Release 2 (9.2.0.2)

Package oracle.AQ

droppublic void drop() throws AQException This method is used to drop a queue

Supplied Java Packages Reference, 9i Release 2 (9.2.0.2)

Package oracle.AQ

droppublic void drop(boolean force) throws AQException This method drops the current queue table

SQL Reference, 9i Release 2 (9.2.0.2)

SQL Statements: CREATE TYPE to DROP ROLLBACK SEGMENT, 25 of 26

DROP ROLEPurpose Use the DROP ROLE statement to remove a role from the database. When you drop a role

Supplied Java Packages Reference, 9i Release 2 (9.2.0.2)

Package oracle.jms

drop(Session)public void drop(javax.jms.Session session) drop the queue/topic Parameters session - the jms

SQL Reference, 9i Release 2 (9.2.0.2)

SQL Statements: CREATE TYPE to DROP ROLLBACK SEGMENT, 12 of 26

DROP DIRECTORYPurpose Use the DROP DIRECTORY statement to remove a directory object from the database. See Also

SQL Reference, 9i Release 2 (9.2.0.2)

SQL Statements: CREATE TYPE to DROP ROLLBACK SEGMENT, 13 of 26

DROP FUNCTIONPurpose Use the DROP FUNCTION statement to remove a standalone stored function from the database … . Note: Do not use this statement to remove a function that is part of a package. Instead, either drop … the entire package using the DROP PACKAGE statement or redefine the package without the function

SQL Reference, 9i Release 2 (9.2.0.2)

SQL Statements: DROP SEQUENCE to ROLLBACK, 7 of 19

DROP TYPEPurpose Use the DROP TYPE statement to drop the specification and body of an object type, a varray … , or nested table type. See Also: DROP TYPE BODY for information on dropping just the body of an

SQL Reference, 9i Release 2 (9.2.0.2)

SQL Statements: CREATE TYPE to DROP ROLLBACK SEGMENT, 9 of 26

DROP CONTEXTPurpose Use the DROP CONTEXT statement to remove a context namespace from the database. Note

SQL Reference, 9i Release 2 (9.2.0.2)

SQL Statements: DROP SEQUENCE to ROLLBACK, 2 of 19

DROP SEQUENCEPurpose Use the DROP SEQUENCE statement to remove a sequence from the database. You can also use … , then you can drop the sequence and then re-create it with the same name and a START WITH value of 27

SQL Reference, 9i Release 2 (9.2.0.2)

SQL Statements: CREATE TYPE to DROP ROLLBACK SEGMENT, 22 of 26

DROP PACKAGEPurpose Use the DROP PACKAGE statement to remove a stored package from the database. This statement

SQL Reference, 9i Release 2 (9.2.0.2)

SQL Statements: CREATE TYPE to DROP ROLLBACK SEGMENT, 11 of 26

DROP DIMENSIONPurpose Use the DROP DIMENSION statement to remove the named dimension. Note: This statement does

SQL Reference, 9i Release 2 (9.2.0.2)

SQL Statements: CREATE TYPE to DROP ROLLBACK SEGMENT, 14 of 26

DROP INDEXPurpose Use the DROP INDEX statement to remove an index or domain index from the database. When you … drop an index, Oracle invalidates all objects that depend on the underlying table, including views … , packages, package bodies, functions, and procedures. When you drop a global partitioned index, a … you drop

SQL Reference, 9i Release 2 (9.2.0.2)

SQL Statements: DROP SEQUENCE to ROLLBACK, 10 of 19

DROP VIEWPurpose Use the DROP VIEW statement to remove a view or an object view from the database. You can

SQL Reference, 9i Release 2 (9.2.0.2)

SQL Statements: DROP SEQUENCE to ROLLBACK, 6 of 19

DROP TRIGGERPurpose Use the DROP TRIGGER statement to remove a database trigger from the database. See Also

SQL Reference, 9i Release 2 (9.2.0.2)

SQL Statements: CREATE TYPE to DROP ROLLBACK SEGMENT, 20 of 26

DROP OPERATORPurpose Use the DROP OPERATOR statement to drop a user-defined operator. See Also: CREATE OPERATOR

SQL Reference, 9i Release 2 (9.2.0.2)

SQL Statements: DROP SEQUENCE to ROLLBACK, 5 of 19

DROP TABLESPACEPurpose Use the DROP TABLESPACE statement to remove a tablespace from the database. See Also

SQL Reference, 9i Release 2 (9.2.0.2)

SQL Statements: CREATE TYPE to DROP ROLLBACK SEGMENT, 23 of 26

DROP PROCEDUREPurpose Use the DROP PROCEDURE statement to remove a standalone stored procedure from the database … . Do not use this statement to remove a procedure that is part of a package. Instead, either drop the … entire package using the DROP PACKAGE statement, or redefine the package without the procedure

SQL Reference, 9i Release 2 (9.2.0.2)

SQL Statements: DROP SEQUENCE to ROLLBACK, 3 of 19

DROP SYNONYMPurpose Use the DROP SYNONYM statement to remove a synonym from the database or to change the

SQL Reference, 9i Release 2 (9.2.0.2)

SQL Statements: CREATE TYPE to DROP ROLLBACK SEGMENT, 8 of 26

DROP CLUSTERPurpose Use the DROP CLUSTER clause to remove a cluster from the database. You cannot uncluster an … and contents as the old one, but with no CLUSTER clause. Drop the old table. Use the RENAME statement … grants on the old clustered table do not apply. See Also: CREATE TABLE, DROP TABLE, RENAME, GRANT for information on these steps

Reference, 9i Release 2 (9.2.0.2)

SQL Statements and Operators

DROP INDEXNote: This section describes the DROP INDEX statement as it pertains to dropping a Text domain … index. For a complete description of the DROP INDEX statement, see Oracle9i SQL Reference.