Package com.alibaba.druid.sql.dialect.oracle.parser

Examples of com.alibaba.druid.sql.dialect.oracle.parser.OracleStatementParser.parseStatementList()

67
68
69
70
71
72
73
74
75
76
77
        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
66
67
68
69
70
71
72
73
74
75
76
        return out.toString();
    }

    public static String formatOracle(String sql) {
        OracleStatementParser parser = new OracleStatementParser(sql);
        List<SQLStatement> statementList = parser.parseStatementList();

        StringBuilder out = new StringBuilder();

        OracleOutputVisitor visitor;
View Full Code Here
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
34
35
36
37
38
39
40
41
42
43
44
                     "      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
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
44
45
46
47
48
49
50
51
52
53
54
                + "      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
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
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
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
29
30
31
32
33
34
35
36
37
38
39
    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
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.