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

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

39
40
41
42
43
44
45
46
47
48
49
                + "    , state_province VARCHAR2(25)" //
                + "    , country_id     CHAR(2)" //
                + "    ) ;";

        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
29
30
31
32
33
34
35
36
37
38
39
    public void test_demo_0() throws Exception {
        String sql = "SELECT SYSDATE FROM DUAL";

        // parser得到AST
        SQLStatementParser parser = new OracleStatementParser(sql);
        List<SQLStatement> stmtList = parser.parseStatementList(); //

        // 将AST通过visitor输出
        StringBuilder out = new StringBuilder();
        OracleOutputVisitor visitor = new OracleOutputVisitor(out);
View Full Code Here
29
30
31
32
33
34
35
36
37
38
39
    public void test_1() throws Exception {
        String sql = "SELECT employees_seq.nextval FROM DUAL;";

        OracleStatementParser parser = new OracleStatementParser(sql);
        List<SQLStatement> statementList = parser.parseStatementList();

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

        String text = output(statementList);
        System.out.println(text);
View Full Code Here
41
42
43
44
45
46
47
48
49
50
51
    public void test_2() throws Exception {
        String sql = "SELECT LPAD(' ',2*(LEVEL-1)) || last_name org_chart, employee_id, manager_id, job_id FROM employees WHERE job_id != 'FI_MGR' START WITH job_id = 'AD_VP' CONNECT BY PRIOR employee_id = manager_id; ";

        OracleStatementParser parser = new OracleStatementParser(sql);
        List<SQLStatement> statementList = parser.parseStatementList();

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

        String text = output(statementList);
        System.out.println(text);
View Full Code Here
29
30
31
32
33
34
35
36
37
38
39
    public void test_0() throws Exception {
        String sql = //
        "alter index PRODUCT_ADDITION_IND1 monitoring usage";

        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
43
44
45
46
47
48
49
50
51
52
53
                "       and el.country = 'US'" + //
                "       and el.logistics_company in ('Hongkong Post Air Mail','Hongkong Post Air Parcel','China Post Air Mail','China Post Air Parcel')" +
                "       and el.recv_status_desc is null) and t.event_date is not null order by t.logistics_no, t.event_date"; //

        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
30
31
32
33
34
35
36
37
38
39
40
    public void test_0() throws Exception {
        String sql = //
        "ALTER TABLE measure_data MODIFY measure_id NUMBER(38)";

        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
36
37
38
39
40
41
42
43
44
45
46
                "        WHERE department_id =  " + //
                "           (SELECT department_id FROM departments" + //
                "               WHERE location_id = 1700); ";

        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
32
33
34
35
36
37
38
39
40
41
42
    public void test_0() throws Exception {
        String sql = "INSERT INTO departments " //
                     + "   VALUES  (departments_seq.nextval, 'Entertainment', 162, 1400); ";

        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
162
163
164
165
166
167
168
169
170
171
172
            update(id, sql, 2);
            return;
        }

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

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

        StringBuilder out = new StringBuilder();
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.