1 | public class SnapshotSourceTab extends OracleSourceTab↵ | | 1 | public class TriggerSourceTab extends BaseSourceTab↵
|
2 | {↵ | | 2 | {↵
|
3 | private static final StringManager s_stringMgr =↵ | | 3 | private static final StringManager s_stringMgr =↵
|
4 | StringManagerFactory.getStringManager(SnapshotSourceTab.class);↵ | | 4 | StringManagerFactory.getStringManager(TriggerSourceTab.class);↵
|
|
|
5 | /** SQL that retrieves the data. */↵ | | 5 | /** SQL that retrieves the source of a stored procedure. */↵
|
6 | private static final String SQL =↵ | | 6 | private static String SQL =↵
|
7 | "SELECT 'CREATE MATERIALIZED VIEW ' || TABLE_NAME || ' AS ', QUERY " +↵ | | |
|
8 | "FROM SYS.ALL_SNAPSHOTS " +↵ | | |
|
9 | "WHERE OWNER = ? AND TABLE_NAME↵ | | 7 | "select trigger_body from sys.all_triggers"↵
|
10 | = ? ";↵ | | 8 | + " where owner = ? and trigger_name = ?";↵
|
11 | ↵ | | |
|
12 | public SnapshotSourceTab()↵ | | 9 | public TriggerSourceTab()↵
|
13 | {↵ | | 10 | {↵
|
14 | // i18n[oracle.displaySnapshotDetails=Display materialized view details]↵ | | 11 | // i18n[oracle.↵
|
15 | super(s_stringMgr.getString("oracle.displaySnapshotDetails"));↵ | | |
|
16 | super.sourceType = OracleSourceTab.TABLE_TYPE↵ | | 12 | showTriggerSource=Show trigger source]↵
|
17 | ;↵ | | 13 | super(s_stringMgr.getString("oracle.showTriggerSource"));↵
|
18 | }↵ | | 14 | }↵
|
|
19 | protected PreparedStatement createStatement() throws SQLException↵ | | 15 | protected PreparedStatement createStatement() throws SQLException↵
|
20 | {↵ | | 16 | {↵
|
21 | ISession session = getSession();↵ | | 17 | final ISession session = getSession();↵
|
22 | PreparedStatement pstmt↵ | | 18 | final IDatabaseObjectInfo doi = getDatabaseObjectInfo();↵
|
|
23 | = session.getSQLConnection().p↵ | | 19 | ISQLConnection conn = session.getSQLConnection();↵
|
24 | repareStatement(SQL);↵ | | 20 | PreparedStatement↵
|
25 | IDatabaseObjectInfo doi = getDatabaseObjectInfo();↵ | | 21 | pstmt = conn.prepareStatement(SQL);↵
|
26 | pstmt.setString(1, doi.getSchemaName());↵ | | 22 | pstmt.setString(1, doi.getSchemaName());↵
|
27 | pstmt.setString(2, doi.getSimpleName());↵ | | 23 | pstmt.setString(2, doi.getSimpleName());↵
|
28 | return pstmt | | 24 | return pstmt
|