GENERATE_DDL_FOR_JAR

Returns a create statement for a named jar.

Syntax

SELECT STATEMENT FROM TABLE(SYS_BOOT.MGMT.GENERATE_DDL_FOR_JAR(catalog_name [optional],<schema_name>,<jar_name>);

where is the name of the schema in which the jar was created and is the name of the jar.

'CREATE OR REPLACE JAR "buses"."GeoIp"'
'LIBRARY 'file:plugin/geoip/geoip.jar''
'OPTIONS(0);'

Example

You can implement this function using the following code:

SELECT STATEMENT FROM TABLE(SYS_BOOT.MGMT.GENERATE_DDL_FOR_JAR('buses', 'GeoIp'));
'STATEMENT'
'CREATE OR REPLACE JAR "buses"."GeoIp"'
'LIBRARY 'file:plugin/geoip/geoip.jar''
'OPTIONS(0);'