Oracle in a Nutshell

Name

CREATE/ALTER/DROP JAVA

Synopsis

CREATE Syntax:

CREATE [OR REPLACE]   [AND {RESOLVE | COMPILE}] [NOFORCE] 
JAVA 
{ {SOURCE | RESOURCE} NAMED [schema.]object_name 
| CLASS [SCHEMA schema]
}
[AUTHID {CURRENT_USER | DEFINER}]
RESOLVER ((match_string[,]{schema_name | -})[(match_string...)])]
{ USING 
  {BFILE (directory_object_name,server_file_name) 
  | { BLOB subquery 
    | CLOB 
    | BFILE 
    }
  | 'key_for_BLOB'
  } 
|
  AS source_text
}

ALTER Syntax:

ALTER JAVA
{SOURCE | CLASS} [schema.]object_name
[RESOLVER ((match_string[,]{schema_name | -})[(match_string...)])]
{COMPILE | RESOLVE}
[AUTHID {CURRENT_USER | DEFINER}]

DROP Syntax:

DROP JAVA {SOURCE | CLASS | RESOURCE} [schema.]object_name

Creates an object containing a Java source, class, or resource; or forces the resolution of a Java class schema object or the compilation of a Java source schema object; or removes a Java object from the database. New with Oracle8i.

Keywords

OR REPLACE

Specifies that the Java object is to be replaced if it already exists.

RESOLVE | COMPILE

Specifies that Oracle should attempt to resolve the Java schema object that is created. The two keywords have identical meaning and are interchangeable.

NOFORCE

Specifies that the results of this statement are to be rolled back if RESOLVE or COMPILE is specified and the resolution fails.

SOURCE

Specifies that a Java source file is to be loaded.

RESOURCE

Specifies that a Java resource file is to be loaded.

object_name

Name of the schema object in which source code is held or which should hold ...