|
Oracle Fusion Middleware Java API Reference for Oracle Extension SDK Reference 11g Release 1 (11.1.1) E13403-03 |
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object oracle.javatools.db.Ddl
public class Ddl
Class for the DDL to create an object. Typically this will contain fragments of DDL statements for secondary objects. For Primary objects, it will contain the complete DDL necessary for the creation of the Object.
The DDL is not one single script. Different aspects of the creation are handled by seperate scripts. For example, table creation has one script to handle the basic creation of the tables and columns. Another script alters the table to add the constraints.
When the DDL fragments for an object are created, they are returned as an instance of a Ddl class. This is a HashTable. The file extension of the DDL script is used as the key.
This is part of the deprecated DDLGenerator
api and has been
replaced with DDL
.
Field Summary | |
---|---|
static java.lang.String |
ACO
DDL type alter tables to add columns |
static java.lang.String |
BODY
DDL type package or type body |
static java.lang.String |
CMC
DDL type Column Comment |
static java.lang.String |
CMT
DDL type Table Comment |
static java.lang.String |
CONCC
DDL type alter table to add constraints |
static java.lang.String |
CONFK
DDL type alter table to add constraints |
static java.lang.String |
CONUK
DDL type alter table to add constraints |
static java.lang.String |
DATABASELINK
DDL type create databaselink |
static java.lang.String |
DROP
DDL type drop an object |
static java.lang.String |
DROP_XMLSCHEMA
DDL type drop a XML Schema object |
static java.lang.String |
DROPCON
DDL type drop a constraint |
static java.lang.String |
DROPMVL
DDL type drop a Materialized View Log |
static java.lang.String |
EVOLVED_TYPE_ALTER
DDL type evolved type ALTER statement |
static java.lang.String |
FLASHBACK
DDL type restore an object |
static java.lang.String |
GRANT
DDL type grant privs |
static java.lang.String |
INCOMPLETE_TYPE
DDL type incomplete. |
static java.lang.String |
IND
DDL type Create Index |
static java.lang.String |
IOT
DDL type alter table oracle index organized table properties |
static java.lang.String |
LOBP
DDL type alter table LOB Parmaters |
static java.lang.String |
MVL
DDL type create materialized view logs |
static java.lang.String |
MVW
DDL type create materialized views |
static java.lang.String |
OET
DDL type alter table oracle external table properties |
static java.lang.String |
RENTAB
DDL type rename table |
static java.lang.String[] |
s_ddlOrder
array of DDL type strings in a reasonable generation order. |
static java.util.HashSet |
s_ddlTerminatorRequired
|
static java.lang.String |
SCHEMA
DDL type create a schema |
static java.lang.String |
SEQ
DDL type Create Sequence |
static java.lang.String |
SPEC
DDL type package or type spec |
static java.lang.String |
SPOOLOFF
DDL type turn spooling off |
static java.lang.String |
SPOOLON
DDL type turn spooling on |
static java.lang.String |
SYN
DDL type Create Synonym |
static java.lang.String |
TAB
DDL type create tables and columns |
static java.lang.String |
TP
DDL type alter table oracle Table Partition properties |
static java.lang.String |
TRG
DDL type create triggers |
static java.lang.String |
TRG_DIS
DDL type disable triggers |
static java.lang.String |
VW
DDL type create views |
static java.lang.String |
XMLSCHEMA
DDL type create XML Schema (N.B. |
Constructor Summary | |
---|---|
Ddl()
Deprecated. - replaced by DDL |
Method Summary | |
---|---|
Ddl |
append(Ddl appendThis)
appends one set of DDL to another |
boolean |
containsKey(java.lang.String key)
true if this key is in the table |
DDL<oracle.javatools.db.ora.ddl.OracleDDLType> |
convertToNew(DBObject obj)
|
java.lang.String |
get(java.lang.String key)
gets an SQL string. |
java.lang.String[] |
getAddConstraints()
Get the DDL for constraints. |
java.lang.String[] |
getArray(java.lang.String key)
gets an array of SQL strings. |
java.util.List |
getArrayList(java.lang.String key)
gets a List of SQL strings. |
java.lang.String[] |
getArrayTrimSlash(java.lang.String key)
gets an array of SQL strings, trim slash from end of SPEC and BODY. |
java.lang.String |
getCreateTable()
Get the DDL for create table |
java.lang.String |
getDdl()
gets all the DDL concatenated into a string SQL*Plus settings first, then create table! SQL*Plus settings are not duplicated. |
java.lang.String |
getDdl(boolean addTerminators)
gets all the DDL concatenated into a string SQL*Plus settings first, then create table! SQL*Plus settings are not duplicated. |
java.lang.String |
getOne(java.lang.String key)
|
java.lang.String |
getSqlTerminator()
get the current SQL statement terminator |
boolean |
isArray(java.lang.String ddlType)
returns true if this DDL type is held as an array of Strings |
java.util.Set |
keySet()
|
void |
put(java.lang.String key,
java.util.Collection sqla)
add an ArrayList of SQL strings to the key |
void |
put(java.lang.String key,
java.lang.String sql)
adds an SQL string to the key |
void |
put(java.lang.String key,
java.lang.String[] sqla)
adds an array of SQL strings to the key |
void |
putOne(java.lang.String key,
java.lang.String sql)
adds an SQL string to the key if it not already present |
void |
setSqlTerminator(java.lang.String terminator)
set an alternative SQL statement terminator |
Ddl |
stripPrompts()
strip out any prompt statements |
Methods inherited from class java.lang.Object |
---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Field Detail |
---|
public static final java.lang.String ACO
public static final java.lang.String CMT
public static final java.lang.String CMC
public static final java.lang.String CONUK
public static final java.lang.String CONFK
public static final java.lang.String CONCC
public static final java.lang.String OET
public static final java.lang.String IOT
public static final java.lang.String TP
public static final java.lang.String LOBP
public static final java.lang.String IND
public static final java.lang.String MVW
public static final java.lang.String MVL
public static final java.lang.String SEQ
public static final java.lang.String SYN
public static final java.lang.String TAB
public static final java.lang.String TRG
public static final java.lang.String TRG_DIS
public static final java.lang.String VW
public static final java.lang.String DROP
public static final java.lang.String DROP_XMLSCHEMA
public static final java.lang.String DROPMVL
public static final java.lang.String FLASHBACK
public static final java.lang.String DROPCON
public static final java.lang.String RENTAB
public static final java.lang.String INCOMPLETE_TYPE
public static final java.lang.String SPEC
public static final java.lang.String EVOLVED_TYPE_ALTER
public static final java.lang.String BODY
public static final java.lang.String SPOOLON
public static final java.lang.String SPOOLOFF
public static final java.lang.String SCHEMA
public static final java.lang.String GRANT
public static final java.lang.String DATABASELINK
public static final java.lang.String XMLSCHEMA
public static final java.lang.String[] s_ddlOrder
public static final java.util.HashSet s_ddlTerminatorRequired
Constructor Detail |
---|
@Deprecated public Ddl()
DDL
Method Detail |
---|
public void setSqlTerminator(java.lang.String terminator)
public java.lang.String getSqlTerminator()
public boolean isArray(java.lang.String ddlType)
public boolean containsKey(java.lang.String key)
public void put(java.lang.String key, java.lang.String sql)
public void putOne(java.lang.String key, java.lang.String sql)
public void put(java.lang.String key, java.lang.String[] sqla)
public void put(java.lang.String key, java.util.Collection sqla)
public java.lang.String get(java.lang.String key)
public java.lang.String getOne(java.lang.String key)
public java.lang.String[] getArray(java.lang.String key)
public java.lang.String[] getArrayTrimSlash(java.lang.String key)
public java.util.List getArrayList(java.lang.String key)
public java.lang.String getCreateTable()
public java.lang.String[] getAddConstraints()
public java.util.Set keySet()
public java.lang.String getDdl()
public java.lang.String getDdl(boolean addTerminators)
public Ddl append(Ddl appendThis)
public Ddl stripPrompts()
public DDL<oracle.javatools.db.ora.ddl.OracleDDLType> convertToNew(DBObject obj)
|
Oracle Fusion Middleware Java API Reference for Oracle Extension SDK Reference 11g Release 1 (11.1.1) E13403-03 |
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |