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

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

48
49
50
51
52
53
54
55
56
57
58
59
                "   COUNT(DISTINCT b.esc_orderid) AS orders , SUM(b.gmv) AS uvGmv, " + //
                "   COUNT(DISTINCT buyer) AS buyers FROM a, b, cp_operate_statistics cos " + //
                "WHERE a.ck = b.oldck(+) AND TO_CHAR(cos.day,'yyyyMMdd') = a.create_time " + //
                "   AND a.create_time = b.buyerpaytime AND a.src_id = cos.src_id GROUP BY a.src_id ORDER BY a.src_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
40
    public void test_0() throws Exception {
        String sql = //
        "select * from abc where model=?"; //

        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
28
29
30
31
32
33
34
35
36
37
38
39
    public void test_0() throws Exception {
        String sql = //
        "EXPLAIN PLAN SET STATEMENT_ID='PLUS19628905' FOR select *   from( select row_.*, rownum rownum_   from( SELECT  h.id taskId, t.id tradeId, t.OUT_ORDER_ID orderId, t.SELLER_SEQ sellerSeq, t.BUYER_SEQ buyerSeq, h.RECORD_TYPE recordType, t.SELLER_LOGIN_ID sellerLoginId, t.SELLER_ADMIN_SEQ sellerAdminSeq, h.GMT_CREATE gmtTaskCreate, h.GMT_MODIFIED gmtTaskModified, h.GMT_FETCH_TASK gmtFetchTask, h.GMT_FINISH_TASK gmtFinishTask, h.STATUS status, h.OWNER owner   FROM HT_TASK_TRADE_HISTORY h, escrow_trade t  WHERE h.TRADE_ID= t.ID    and h.OWNER='zhoufei.zhangzf'    and h.STATUS in('running') ORDER BY h.TASK_FLOW_LEVEL, t.GMT_CREATE, h.GMT_MODIFIED DESC) row_ where rownum<= 100)  where rownum_>= 80";

        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
28
29
30
31
32
33
34
35
36
37
38
39
    public void test_0() throws Exception {
        String sql = //
        "alter index    PRODUCT_ADDITION_NCID_IND parallel 1";

        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
41
    public void test_0() throws Exception {
        String sql = //
        "DROP TRIGGER hr.salary_check; ";

        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 TRIGGER hr.salary_check",
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 (select decode(count(*),1,'YES','NO') FROM sys.obj$ o, sys.user$ u WHERE u.name = 'PERFSTAT' AND o.owner# = u.user# AND o.name = 'STATSPACK' AND o.type# = 11 AND o.status = 1) is_installed , (select  nvl(INTERVAL,'') from dba_jobs where what like 'statspack.snap%' and SCHEMA_USER='PERFSTAT' and rownum =1) freq from dual"; //

        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
28
29
30
31
32
33
34
35
36
37
38
39
    public void test_0() throws Exception {
        String sql = //
        "alter index TAXI.AE_ID_AU_CATE_PROD_HMK_TMP_IND rebuild";

        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
                     "   (SELECT * FROM employees " + //
                     "       WHERE departments.department_id = employees.department_id " + //
                     "       AND employees.salary > 2500)" + //
                     "   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
28
29
30
31
32
33
34
35
36
37
38
39
public class OracleSchemaStatVisitorTest_Delete extends TestCase {

    public void test_0() throws Exception {
        String sql = "delete from users where id = ? or name = ?";

        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
35
36
37
38
39
40
41
42
43
44
45
46
                + "    (div_no     NUMBER(2), " //
                + "     div_name   VARCHAR2(14), "//
                + "     location   VARCHAR2(13) ) " //
                + "     STORAGE  ( INITIAL 8M MAXSIZE 1G );";

        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
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.