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

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

29
30
31
32
33
34
35
36
37
38
39
40
    public void test_0() throws Exception {
        String sql = //
        "alter table PRODUCT_IDS_ZZJ_TBD0209 move tablespace MCSHADOWTS";

        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
40
41
42
43
44
45
46
47
48
49
50
51
                     "SELECT * FROM dept_costs" + //
                     "   WHERE dept_total >" + //
                     "      (SELECT avg FROM avg_cost)" + //
                     "      ORDER BY department_name;";

        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
46
47
48
49
50
51
52
53
54
55
56
57
                + "DELETE_REASON_ NVARCHAR2(2000), "//
                + "primary key (ID_), "//
                + "unique (PROC_INST_ID_) "//
                + ")";

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

        Assert.assertEquals(1, statementList.size());
View Full Code Here
39
40
41
42
43
44
45
46
47
48
49
50
        String sql = "select * from user where uid = ? and uname = ?";
        List<Object> parameters = new ArrayList<Object>();
        parameters.add(1);
        parameters.add("wenshao");

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

        SQLStatement first = (SQLStatement) stmtList.get(0);

        GetVariantVisitor variantVisitor = new GetVariantVisitor();
        first.accept(variantVisitor);
View Full Code Here
28
29
30
31
32
33
34
35
36
37
38
39
    public void test_0() throws Exception {
        String sql = //
        "SELECT NULL FROM DUAL FOR UPDATE NOWAIT"; //

        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
33
34
35
36
37
38
39
40
41
42
43
44
        String expect = "SELECT country, prod, year, s\n" + "FROM sales_view\n" + "MODEL\n"
                        + "\tPARTITION BY (country)\n" + "\tDIMENSION BY (prod, year)\n" + "\tMEASURES (sale s)\n"
                        + "\tIGNORE NAV\n" + "\tUNIQUE DIMENSION\n"
                        + "\tRULES UPSERT SEQUENTIAL ORDER (s[ANY, 2000] = 0)\n" + "ORDER BY country, prod, year;\n";

        OracleStatementParser parser = new OracleStatementParser(sql);
        SQLSelectStatement stmt = (SQLSelectStatement) parser.parseStatementList().get(0);

        String text = TestUtils.outputOracle(stmt);

        Assert.assertEquals(expect, text);
View Full Code Here
28
29
30
31
32
33
34
35
36
37
38
39
public class OracleSchemaStatVisitorTest2 extends TestCase {

    public void test_0() throws Exception {
        String sql = "select id, name FROM users";

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

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

        OracleSchemaStatVisitor visitor = new OracleSchemaStatVisitor();
View Full Code Here
53
54
55
56
57
58
59
60
61
62
63
64
    }

    public void test_2() throws Exception {
        String sql = "select id, name FROM users a";

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

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

        OracleSchemaStatVisitor visitor = new OracleSchemaStatVisitor();
View Full Code Here
78
79
80
81
82
83
84
85
86
87
88
89
    }

    public void test_3() throws Exception {
        String sql = "select id, a.name FROM users a";

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

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

        OracleSchemaStatVisitor visitor = new OracleSchemaStatVisitor();
View Full Code Here
44
45
46
47
48
49
50
51
52
53
54
55
                     "      end if;" + //
                     "  end loop;" + //
                     "  commit; " + //
                     "end;";

        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

Related Classes of com.alibaba.druid.sql.dialect.oracle.parser.OracleStatementParser

  • com.alibaba.druid.bvt.sql.oracle.LargeOrTest
  • com.alibaba.druid.bvt.sql.oracle.OracleAnalyticTest
  • com.alibaba.druid.bvt.sql.oracle.OracleCreateDbLinkTest
  • com.alibaba.druid.bvt.sql.oracle.OracleDropDbLinkTest
  • com.alibaba.druid.bvt.sql.oracle.OracleIntervalTest
  • com.alibaba.druid.bvt.sql.oracle.OracleLiteralTest
  • com.alibaba.druid.bvt.sql.oracle.OracleNumberLiteralTest
  • com.alibaba.druid.bvt.sql.oracle.OraclePivotClauseTest
  • com.alibaba.druid.bvt.sql.oracle.OraclePriorTest
  • com.alibaba.druid.bvt.sql.oracle.OracleSampleClauseTest
    • Copyright © 2018 www.massapicom. 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.