public class IndexDetailsTab extends BasePreparedStatementTab { private static final StringManager s_stringMgr = StringManagerFactory.getStringManager(IndexDetailsTab.class); /** * This interface defines locale specific strings. This should be * replaced with a property file. */ private interface i18n { // i18n[IndexDetailsTab.title=Details] String TITLE = s_stringMgr.getString("IndexDetailsTab.title"); // i18n[IndexDetailsTab.hint=Display index details] String HINT = s_stringMgr.getString("IndexDetailsTab.hint"); } /** SQL that retrieves the data. */ private static final String SQL = "SELECT TABLE_CATALOG,TABLE_SCHEMA,TABLE_NAME, " + "NON_UNIQUE,ORDINAL_POSITION,COLUMN_NAME, " + "CARDINALITY,PRIMARY_KEY,INDEX_TYPE_NAME, " + "IS_GENERATED,INDEX_TYPE,ASC_OR_DESC,PAGES, " + "FILTER_CONDITION,REMARKS " + "FROM INFORMATION_SCHEMA.INDEXES " + "WHERE TABLE_SCHEMA = ? " + "AND INDEX_NAME = ? "; public IndexDetailsTab() { super(i18n.TITLE, i18n.HINT, true); } protected PreparedStatement createStatement() throws SQLException { ISession session = getSession(); PreparedStatement pstmt = session.getSQLConnection().prepareStatement(SQL); IDatabaseObjectInfo doi = getDatabaseObjectInfo(); pstmt.setString(1, doi.getSchemaName()); pstmt.setString(2, doi.getSimpleName()); return pstmt
public class TriggerDetailsTab extends BasePreparedStatementTab { private static final StringManager s_stringMgr = StringManagerFactory.getStringManager(TriggerDetailsTab.class); /** * This interface defines locale specific strings. This should be * replaced with a property file. */ private interface i18n { // i18n[oracle.triggerDetails=Details] String TITLE = s_stringMgr.getString("oracle.triggerDetails"); // i18n[oracle.displayTriggerDetails=Display trigger details] String HINT = s_stringMgr.getString("oracle.displayTriggerDetails"); } /** SQL that retrieves the data. */ private static String SQL = "select t.owner, t.trigger_name, t.trigger_type, t.triggering_event, t.table_owner, " + " t.base_object_type, t.table_name, t.column_name, " + " t.referencing_names, t.when_clause, t.status, t.description, t.action_type, o.status as validity " + " from sys.all_triggers t, user_objects o " + " where t.trigger_name = o.OBJECT_NAME " + " and t.owner = ? " + " and t.trigger_name = ? "; public TriggerDetailsTab() { super(i18n.TITLE, i18n.HINT, true); } protected PreparedStatement createStatement() throws SQLException { ISession session = getSession(); PreparedStatement pstmt = session.getSQLConnection().prepareStatement(SQL); IDatabaseObjectInfo doi = getDatabaseObjectInfo(); pstmt.setString(1, doi.getSchemaName()); pstmt.setString(2, doi.getSimpleName()); return pstmt
Clone fragments detected by clone detection tool
File path: /sql12/plugins/h2/src/net/sourceforge/squirrel_sql/plugins/h2/tab/IndexDetailsTab.java File path: /sql12/plugins/oracle/src/net/sourceforge/squirrel_sql/plugins/oracle/tab/TriggerDetailsTab.java
Method name: Method name:
Number of AST nodes: 0 Number of AST nodes: 0
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
Summary
Number of common nesting structure subtrees0
Number of refactorable cases0
Number of non-refactorable cases0
Time elapsed for finding largest common nesting structure subtrees (ms)0.0
Clones location
Number of node comparisons0