Examples of OracleStatementParser

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

33
34
35
36
37
38
39
40
41
42
43
44
        String sql = //
        "ALTER TABLE employees ADD CONSTRAINT check_comp " //
                + "   CHECK (salary + (commission_pct*salary) <= 5000)" //
                + "   DISABLE;";

        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

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

34
35
36
37
38
39
40
41
42
43
44
45
    public void test_0() throws Exception {
        String sql = //
        "select ID,name from druid_test where (name>=? or name is null) and card_id<?"; //

        OracleStatementParser parser = new OracleStatementParser(sql);
        List<SQLStatement> statementList = parser.parseStatementList();
        SQLStatement statemen = statementList.get(0);
        print(statementList);
       
        {
            SQLSelect select = ((SQLSelectStatement) statemen).getSelect();
View Full Code Here

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

33
34
35
36
37
38
39
40
41
42
43
44
                     "          select distinct  parent_id parentId      from BUSINESS_ORDER a1      " + //
                     "          where SELLER_SEQ in                        ( ?)     " + //
                     "              and not (order_from = 'safepay' and status in ('buyer_create', 'closed'))     " + //
                     "              ) b, business_order c where ID = b.parentId"; //

        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

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

34
35
36
37
38
39
40
41
42
43
44
45
                     + " MEMBER_DEPT_CN, LINK_EMAIL, STATUS, AV_PROVIDER, AV_ORIGIN)"
                     + " values (1000236058, sysdate, sysdate, 1300904670, '��������5''TW'"
                     + ", 'Yunnan', 'sadf', '4r7V', 'fdgtg', 'M', '�����info_name4', 'Fnameinfo_name4'"
                     + ", '33', '4444', '6666', '���fgsgsdfg', 'fggtgth', '�������������', null, 'zeus'" + ")";

        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

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

55
56
57
58
59
60
61
62
63
64
65
66
                     "  WHEN DUP_VAL_ON_INDEX THEN" + //
                     "    ROLLBACK TO do_insert;" + //
                     "  DBMS_OUTPUT.PUT_LINE('Insert was rolled back');" + //
                     "END;"; //

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

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

        OracleSchemaStatVisitor visitor = new OracleSchemaStatVisitor();
View Full Code Here

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

28
29
30
31
32
33
34
35
36
37
38
39
    public void test_0() throws Exception {
        String sql = //
        "ALTER SYNONYM \"ESCROW\".\"COMPANY\" 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

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

39
40
41
42
43
44
45
46
47
48
49
50
                "   , '', dtf.autoextensible autoextensible, dtf.increment_by increment_by" + //
                "   , dtf.maxbytes max_file_size, vtf.create_bytes " + //
                "FROM sys.dba_temp_files dtf, v$tempfile vtf " + //
                "WHERE (dtf.file_id = vtf.file#) "; //

        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

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 = //
        "CREATE GLOBAL TEMPORARY TABLE \"SYS\".\"SYS_TEMP_0FD9D66FD_93E068F3\" (\"C0\" NUMBER,\"C1\" NUMBER ) IN_MEMORY_METADATA CURSOR_SPECIFIC_SEGMENT STORAGE (OBJNO 4254951165 ) NOPARALLEL";

        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

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

43
44
45
46
47
48
49
50
51
52
53
54
                + "   ) SEGMENT CREATION DEFERRED " //
                + "  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 " //
                + " NOCOMPRESS LOGGING" //
                + "  TABLESPACE \"USERS\" ;";

        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

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

42
43
44
45
46
47
48
49
50
51
52
53
                + "    department_id, " //
                + "   CONSTRAINT fk_deptno " //
                + "      FOREIGN  KEY (department_id) " //
                + "      REFERENCES  departments(department_id) ); ";

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