Oracle8i SQL Reference
Release 2 (8.1.6)

A76989-01

Library

Product

Contents

Index

Prev Up Next

SQL Statements (continued), 8 of 30


DROP JAVA

Syntax


Purpose

To drop a Java source, class, or resource schema object.

See Also:

Oracle8i Java Stored Procedures Developer's Guide for more information on resolving Java sources, classes, and resources. 

Prerequisites

The Java source, class, or resource must be in your own schema or you must have the DROP ANY PROCEDURE system privilege. You also must have the EXECUTE object privilege on Java classes to use this command.

Keywords and Parameters

JAVA SOURCE 

drops a Java source schema object and all Java class schema objects derived from it. 

JAVA CLASS 

drops a Java class schema object. 

JAVA RESOURCE 

drops a Java resource schema object. 

object_name 

specifies the name of an existing Java class, source, or resource schema object. Enclose the object_name in double quotation marks to preserve lower- or mixed-case names. 

Example

The following statement drops the Java class MyClass:

DROP JAVA CLASS "MyClass";

Prev Up Next
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index