Examples of OracleStatementParser

Examples of com.alibaba.druid.sql.dialect.oracle.parser.OracleStatementParser

12
13
14
15
16
17
18
19
20
21
22
public class SQLParserUtils {

    public static SQLStatementParser createSQLStatementParser(String sql, String dbType) {
        if (JdbcUtils.ORACLE.equals(dbType)) {
            return new OracleStatementParser(sql);
        }

        if (JdbcUtils.MYSQL.equals(dbType)) {
            return new MySqlStatementParser(sql);
        }
View Full Code Here

Examples of com.alibaba.druid.sql.dialect.oracle.parser.OracleStatementParser

67
68
69
70
71
72
73
74
75
76
77
78
        return out.toString();
    }

    public static String mergeOracle(String sql) {
        OracleStatementParser parser = new OracleStatementParser(sql);
        List<SQLStatement> statementList = parser.parseStatementList();
        SQLStatement statemen = statementList.get(0);

        Assert.isTrue(1 == statementList.size());

        StringBuilder out = new StringBuilder();
View Full Code Here

Examples of com.alibaba.druid.sql.dialect.oracle.parser.OracleStatementParser

33
34
35
36
37
38
39
40
41
42
43
44
                     "   WHERE salary > (SELECT AVG(salary) " + //
                     "      FROM employees " + //
                     "      WHERE x.department_id = department_id) " + //
                     "   ORDER BY department_id; ";

        OracleStatementParser parser = new OracleStatementParser(sql);
        List<SQLStatement> statementList = parser.parseStatementList();
        SQLStatement statemen = statementList.get(0);
        print(statementList);

        Assert.assertEquals(1, statementList.size());
View Full Code Here

Examples of com.alibaba.druid.sql.dialect.oracle.parser.OracleStatementParser

28
29
30
31
32
33
34
35
36
37
38
39
    public void test_0() throws Exception {
        String sql = //
        "alter trigger DDL_TRIGGER_FOR_DATABASE ENABLE";

        OracleStatementParser parser = new OracleStatementParser(sql);
        List<SQLStatement> statementList = parser.parseStatementList();
        SQLStatement statemen = statementList.get(0);
        print(statementList);

        Assert.assertEquals(1, statementList.size());
View Full Code Here

Examples of com.alibaba.druid.sql.dialect.oracle.parser.OracleStatementParser

43
44
45
46
47
48
49
50
51
52
53
54
                + "      CONSTRAINT nn_qty NOT NULL " //
                + "      CONSTRAINT check_qty CHECK (quantity > 0), " //
                + "   cost        NUMBER " //
                + "      CONSTRAINT check_cost CHECK (cost > 0) ); ";

        OracleStatementParser parser = new OracleStatementParser(sql);
        List<SQLStatement> statementList = parser.parseStatementList();
        SQLStatement stmt = statementList.get(0);
        print(statementList);

        Assert.assertEquals(1, statementList.size());
View Full Code Here

Examples of com.alibaba.druid.sql.dialect.oracle.parser.OracleStatementParser

30
31
32
33
34
35
36
37
38
39
40
41
    public void test_0() throws Exception {
        String sql = //
        "DROP view list_customers CASCADE CONSTRAINTS";

        OracleStatementParser parser = new OracleStatementParser(sql);
        List<SQLStatement> statementList = parser.parseStatementList();
        SQLStatement stmt = statementList.get(0);
        print(statementList);

        Assert.assertEquals("DROP VIEW list_customers CASCADE CONSTRAINTS",
                            SQLUtils.toSQLString(stmt, JdbcConstants.ORACLE));
View Full Code Here

Examples of com.alibaba.druid.sql.dialect.oracle.parser.OracleStatementParser

28
29
30
31
32
33
34
35
36
37
38
39
    public void test_0() throws Exception {
        String sql = //
        "alter TRIGGER RETL.TRG_COMPANY_SYNC compile";

        OracleStatementParser parser = new OracleStatementParser(sql);
        List<SQLStatement> statementList = parser.parseStatementList();
        SQLStatement statemen = statementList.get(0);
        print(statementList);

        Assert.assertEquals(1, statementList.size());
View Full Code Here

Examples of com.alibaba.druid.sql.dialect.oracle.parser.OracleStatementParser

30
31
32
33
34
35
36
37
38
39
40
41
    public void test_0() throws Exception {
        String sql = //
        "DROP TABLE list_customers PURGE";

        OracleStatementParser parser = new OracleStatementParser(sql);
        List<SQLStatement> statementList = parser.parseStatementList();
        SQLStatement stmt = statementList.get(0);
        print(statementList);
        Assert.assertEquals(1, statementList.size());

        Assert.assertEquals("DROP TABLE list_customers PURGE",
View Full Code Here

Examples of com.alibaba.druid.sql.dialect.oracle.parser.OracleStatementParser

28
29
30
31
32
33
34
35
36
37
38
39
public class OracleIbatisSelectTest extends OracleTest {

    public void test_0() throws Exception {
        String sql = "SELECT * FROM T WHERE F1 = #id# ";

        OracleStatementParser parser = new OracleStatementParser(sql);
        List<SQLStatement> statementList = parser.parseStatementList();
        SQLStatement statemen = statementList.get(0);
        print(statementList);

        Assert.assertEquals(1, statementList.size());

View Full Code Here

Examples of com.alibaba.druid.sql.dialect.oracle.parser.OracleStatementParser

32
33
34
35
36
37
38
39
40
41
42
43
                     "employee_id, manager_id, job_id " + //
                     "    FROM employees" + //
                     "    START WITH job_id = 'AD_PRES' " + //
                     "    CONNECT BY PRIOR employee_id = manager_id AND LEVEL <= 2;";

        OracleStatementParser parser = new OracleStatementParser(sql);
        List<SQLStatement> statementList = parser.parseStatementList();
        SQLStatement statemen = statementList.get(0);
        print(statementList);

        Assert.assertEquals(1, statementList.size());
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.