|
Oracle Fusion Middleware Java API Reference for Oracle Extension SDK 11g Release 2 (11.1.2.3.0) E17493-04 |
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object
oracle.ide.db.panels.sql.SQLQueryEditDialog
public final class SQLQueryEditDialog
Dialog launcher for editing SQL queries.
Field Summary | |
---|---|
static java.lang.String |
HELP_CONNECTBY_INFO |
static java.lang.String |
HELP_FROM_INFO |
static java.lang.String |
HELP_GROUPBY_INFO |
static java.lang.String |
HELP_HAVING_INFO |
static java.lang.String |
HELP_JOIN_INFO Deprecated. - we no longer use the "FK Joins" panel. |
static java.lang.String |
HELP_ORDERBY_INFO |
static java.lang.String |
HELP_PICKER |
static java.lang.String |
HELP_QUERY_INFO |
static java.lang.String |
HELP_SELECT_INFO |
static java.lang.String |
HELP_WHERE_INFO |
Constructor Summary | |
---|---|
SQLQueryEditDialog() Creates a new launcher for an edit dialog for sql queries. |
|
SQLQueryEditDialog(boolean materializedView) Creates a new launcher for an edit dialog for sql queries. |
|
SQLQueryEditDialog(java.lang.String[] helpIDs) Creates a new launcher with custom help IDs for the panels. |
Method Summary | |
---|---|
int |
compare(java.lang.Object o1, java.lang.Object o2) Dummy Comparator implementation that always returns equal. |
SQLQuery |
editQuery(SQLQuery query, DBObjectProvider provider, Schema defaultSchema) Edits the given query. |
SQLQuery |
editQuery(SQLQuery query, SQLFragment defaultObject, DBObjectProvider provider, Schema defaultSchema) Edits the given query. |
java.lang.String |
editQuery(java.lang.String sqlText, DBObjectProvider provider, Schema defaultSchema) Edits the given query sql text. |
Navigable |
getMasterNavigable() Returns a master Navigable object that has all the required child naviagables for editing a query. |
Navigable[] |
getNavigables() Returns a set of Navigable objects for the pages required to edit a SQLQuery. |
static java.lang.String[] |
getStartPage(SQLFragment child, boolean incMaster) Returns the appropriate start page path for editing the given child of a query. |
Step[] |
getSteps() Returns a set of Step objects for the pages required to creating a SQLQuery. |
static boolean |
isAvailable(DBObjectProvider pro) Returns true if the SQLQueryEditDialog support the given provider. |
void |
setBindVariables(java.util.Collection<java.lang.String> bindVars) |
Methods inherited from class java.lang.Object |
---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Methods inherited from interface java.util.Comparator |
---|
equals |
Field Detail |
---|
public static final java.lang.String HELP_PICKER
public static final java.lang.String HELP_SELECT_INFO
public static final java.lang.String HELP_FROM_INFO
public static final java.lang.String HELP_WHERE_INFO
public static final java.lang.String HELP_GROUPBY_INFO
public static final java.lang.String HELP_HAVING_INFO
public static final java.lang.String HELP_ORDERBY_INFO
public static final java.lang.String HELP_CONNECTBY_INFO
public static final java.lang.String HELP_QUERY_INFO
@Deprecated
public static final java.lang.String HELP_JOIN_INFO
Constructor Detail |
---|
public SQLQueryEditDialog()
public SQLQueryEditDialog(boolean materializedView)
materializedView
- if building query for a MV, the Ordre By panel will not be shown.public SQLQueryEditDialog(java.lang.String[] helpIDs)
Method Detail |
---|
public Navigable[] getNavigables()
public void setBindVariables(java.util.Collection<java.lang.String> bindVars)
public Navigable getMasterNavigable()
public Step[] getSteps()
public java.lang.String editQuery(java.lang.String sqlText, DBObjectProvider provider, Schema defaultSchema) throws SQLQueryException
sqlText
- the query text to editprovider
- the provider to usedefaultSchema
- the default schema for the query (can be null).SQLQueryException
public SQLQuery editQuery(SQLQuery query, DBObjectProvider provider, Schema defaultSchema) throws SQLQueryException
query
- the query to editprovider
- the provider to usedefaultSchema
- the default schema for the query.SQLQueryException
public SQLQuery editQuery(SQLQuery query, SQLFragment defaultObject, DBObjectProvider provider, Schema defaultSchema) throws SQLQueryException
query
- the query to editdefaultObject
- the default object within the query to start the edit withprovider
- the provider to usedefaultSchema
- the default schema for the querySQLQueryException
public int compare(java.lang.Object o1, java.lang.Object o2)
compare
in interface java.util.Comparator
public static final java.lang.String[] getStartPage(SQLFragment child, boolean incMaster)
child
- the child of the query whose page we require.incMaster
- whether the master panel is inculded in the path.public static boolean isAvailable(DBObjectProvider pro)
|
Oracle Fusion Middleware Java API Reference for Oracle Extension SDK 11g Release 2 (11.1.2.3.0) E17493-04 |
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |