1 | public class IndexDetailsTab extends BasePreparedStatementTab↵ | | 1 | public class TriggerDetailsTab extends BasePreparedStatementTab↵
|
2 | {↵ | | 2 | {↵
|
3 | private static final StringManager s_stringMgr =↵ | | 3 | private static final StringManager s_stringMgr =↵
|
4 | StringManagerFactory.getStringManager(IndexDetailsTab.class);↵ | | 4 | StringManagerFactory.getStringManager(TriggerDetailsTab.class);↵
|
|
|
5 | /**↵ | | 5 | /**↵
|
6 | * This interface defines locale specific strings. This should be↵ | | 6 | * This interface defines locale specific strings. This should be↵
|
7 | * replaced with a property file.↵ | | 7 | * replaced with a property file.↵
|
8 | */↵ | | 8 | */↵
|
9 | private interface i18n↵ | | 9 | private interface i18n↵
|
10 | {↵ | | 10 | {↵
|
11 | // i18n[IndexDetailsTab.title=Details]↵ | | 11 | // i18n[oracle.triggerDetails=Details]↵
|
12 | String TITLE = s_stringMgr.getString("IndexDetailsTab.title");↵ | | 12 | String TITLE = s_stringMgr.getString("↵
|
13 | // i18n[IndexDetailsTab.hint↵ | | 13 | oracle.triggerDetails");↵
|
14 | =Display index details]↵ | | 14 | // i18n[oracle.displayTriggerDetails=Display trigger details]↵
|
15 | String HINT = s_stringMgr.getString("IndexDetailsTab.hint");↵ | | 15 | String HINT = s_stringMgr.getString("oracle.displayTriggerDetails");↵
|
16 | }↵ | | 16 | }↵
|
|
17 | /** SQL that retrieves the data. */↵ | | 17 | /** SQL that retrieves the data. */↵
|
18 | private static final String SQL =↵ | | 18 | private static String SQL =↵
|
19 | "SELECT TABLE_CATALOG,TABLE_SCHEMA,TABLE_NAME, " +↵ | | |
|
20 | "NON_UNIQUE,ORDINAL_POSITION,COLUMN_NAME, " +↵ | | |
|
21 | "CARDINALITY,PRIMARY_KEY,INDEX_TYPE_NAME, " +↵ | | |
|
22 | "IS_GENERATED,INDEX_TYPE,ASC_OR_DESC,PAGES, " +↵ | | |
|
23 | "FILTER_CONDITION,REMARKS " +↵ | | |
|
24 | "FROM INFORMATION_SCHEMA.INDEXES " +↵ | | |
|
25 | "WHERE TABLE_SCHEMA = ? " +↵ | | |
|
26 | "AND INDEX_NAME = ? ";↵ | | |
|
27 | ↵ | | 19 | "select t.owner, t.trigger_name, t.trigger_type, t.triggering_event, t.table_owner, " +↵
|
| | | 20 | " t.base_object_type, t.table_name, t.column_name, " +↵
|
| | | 21 | " t.referencing_names, t.when_clause, t.status, t.description, t.action_type, o.status as validity " +↵
|
| | | 22 | " from sys.all_triggers t, user_objects o " +↵
|
| | | 23 | " where t.trigger_name = o.OBJECT_NAME " +↵
|
| | | 24 | " and t.owner = ? " +↵
|
| | | 25 | " and t.trigger_name = ? ";↵
|
|
|
28 | public IndexDetailsTab()↵ | | 26 | public TriggerDetailsTab()↵
|
29 | {↵ | | 27 | {↵
|
30 | super(i18n.TITLE, i18n.HINT, true);↵ | | 28 | super(i18n.TITLE, i18n.HINT, true);↵
|
31 | }↵ | | 29 | }↵
|
|
32 | protected PreparedStatement createStatement() throws SQLException↵ | | 30 | protected PreparedStatement createStatement() throws SQLException↵
|
33 | {↵ | | 31 | {↵
|
34 | ISession session = getSession();↵ | | 32 | ISession session = getSession();↵
|
35 | PreparedStatement pstmt = session.getSQLConnection().prepareStatement(SQL);↵ | | 33 | PreparedStatement pstmt = session.getSQLConnection().prepareStatement(SQL);↵
|
36 | IDatabaseObjectInfo doi = getDatabaseObjectInfo();↵ | | 34 | IDatabaseObjectInfo doi = getDatabaseObjectInfo();↵
|
37 | pstmt.setString(1, doi.getSchemaName());↵ | | 35 | pstmt.setString(1, doi.getSchemaName());↵
|
38 | pstmt.setString(2, doi.getSimpleName());↵ | | 36 | pstmt.setString(2, doi.getSimpleName());↵
|
39 | return pstmt | | 37 | return pstmt
|