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

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

26
27
28
29
30
31
32
33
34
35
36
37
public class OracleIntervalTest extends TestCase {

    public void test_interval_literal() throws Exception {
        String sql = "SELECT INTERVAL '123-2' YEAR(3) TO MONTH FROM DUAL";

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

        String text = TestUtils.outputOracle(stmt);

        Assert.assertEquals("SELECT INTERVAL '123-2' YEAR(3) TO MONTH\nFROM DUAL;\n", text);
View Full Code Here
39
40
41
42
43
44
45
46
47
48
49
50
    }

    public void test_interval_literal_1() throws Exception {
        String sql = "SELECT INTERVAL '123' YEAR(3) FROM DUAL";

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

        String text = TestUtils.outputOracle(stmt);

        Assert.assertEquals("SELECT INTERVAL '123' YEAR(3)\nFROM DUAL;\n", text);
View Full Code Here
52
53
54
55
56
57
58
59
60
61
62
63
    }

    public void test_interval_literal_2() throws Exception {
        String sql = "SELECT INTERVAL '5-3' YEAR TO MONTH + INTERVAL'20' MONTH FROM DUAL";

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

        String text = TestUtils.outputOracle(stmt);

        Assert.assertEquals("SELECT INTERVAL '5-3' YEAR TO MONTH + INTERVAL '20' MONTH\nFROM DUAL;\n", text);
View Full Code Here
65
66
67
68
69
70
71
72
73
74
75
76
    }

    public void test_interval_literal_3() throws Exception {
        String sql = "SELECT INTERVAL '6-11' YEAR TO MONTH FROM DUAL";

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

        String text = TestUtils.outputOracle(stmt);

        Assert.assertEquals("SELECT INTERVAL '6-11' YEAR TO MONTH\nFROM DUAL;\n", text);
View Full Code Here
78
79
80
81
82
83
84
85
86
87
88
89
    }

    public void test_interval_literal_4() throws Exception {
        String sql = "SELECT INTERVAL '4 5:12:10.222' DAY TO SECOND(3) FROM DUAL";

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

        String text = TestUtils.outputOracle(stmt);

        Assert.assertEquals("SELECT INTERVAL '4 5:12:10.222' DAY TO SECOND(3)\nFROM DUAL;\n", text);
View Full Code Here
91
92
93
94
95
96
97
98
99
100
101
102
    }

    public void test_interval_literal_5() throws Exception {
        String sql = "SELECT INTERVAL '30.12345' SECOND(2,4) FROM DUAL";

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

        String text = TestUtils.outputOracle(stmt);

        Assert.assertEquals("SELECT INTERVAL '30.12345' SECOND(2, 4)\nFROM DUAL;\n", text);
View Full Code Here
104
105
106
107
108
109
110
111
112
113
114
115
    }

    public void test_interval() throws Exception {
        String sql = "SELECT (SYSTIMESTAMP - order_date) DAY(9) TO SECOND from orders WHERE order_id = 2458;";

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

        String text = TestUtils.outputOracle(stmt);

        Assert.assertEquals("SELECT (SYSTIMESTAMP - order_date) DAY(9) TO SECOND\n" + "FROM orders\n"
                            + "WHERE order_id = 2458;\n", text);
View Full Code Here
29
30
31
32
33
34
35
36
37
38
39
40
41
public class OracleAlterTableTest_drop_constraint extends TestCase {

    public void test_alter_constraint() throws Exception {
        String sql = "alter table TUSER drop constraint UK_084c17821a8f47e8b31fbb126b6";
        OracleStatementParser parser = new OracleStatementParser(sql);
        SQLStatement stmt = parser.parseStatementList().get(0);
        parser.match(Token.EOF);

        OracleSchemaStatVisitor visitor = new OracleSchemaStatVisitor();
        stmt.accept(visitor);

        System.out.println("Tables : " + visitor.getTables());
View Full Code Here
29
30
31
32
33
34
35
36
37
38
39
40
    public void test_0() throws Exception {
        String sql = "SELECT t1.department_id, t2.* FROM hr_info t1, TABLE(t1.people) t2" + //
                     "   WHERE t2.department_id = t1.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
32
33
34
35
36
37
38
39
40
41
42
43
                "   sys.dbms_stats.gather_table_stats(" + //
                "       ownname => 'ESCROW',tabname => 'HT_TASK_TRADE_HISTORY',estimate_percent=>0.5, cascade => TRUE" + //
                "       ,method_opt=>'FOR ALL COLUMNS SIZE 1',no_invalidate => false); " + //
                "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.