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
                     "\"COUNTRY_ACCORD_NAME\",\"P_NAME\",\"P_VALUE\",\"CLICK_CNT\"" + //
                     ") " + "SELECT \"A2\".\"P_M\",\"A2\".\"KEYWORD\",\"A2\".\"REGION_NAME\"" + //
                     "  ,\"A2\".\"COUNTRY_NAME\",\"A2\".\"P_NAME\",\"A2\".\"P_VALUE\",\"A2\".\"CLICK_CNT\" " + //
                     "FROM \"ZFJ_EN_CLICK_201202\"@! \"A2\"";

        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

28
29
30
31
32
33
34
35
36
37
38
39
public class OracleSchemaStatVisitorTest1 extends TestCase {

    public void test_0() throws Exception {
        String sql = "select a.name, b.name FROM users a, usergroups b on a.groupId = b.id";

        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

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

56
57
58
59
60
61
62
63
64
65
66
67
    }

    public void test_1() throws Exception {
        String sql = "select a.name, b.name FROM users a, usergroups b on a.groupId = b.id where a.groupID = ?";

        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

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

40
41
42
43
44
45
46
47
48
49
50
51
                     "WHERE (file#, creation_change#) IN        (" + //
                     "          SELECT tf.tfnum, to_number(tf.tfcrc_scn) creation_change#           " + //
                     "          FROM x$kcctf tf           " + //
                     "          WHERE tf.tfdup != 0)    AND dbid    = :dbid    AND snap_id < :snap_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

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

31
32
33
34
35
36
37
38
39
40
41
42
        String sql = //
        "SELECT UNIQUE  * FROM ONLY (t_department)  " + //
                "WHERE name IN ('0000','4444') " + //
                "ORDER BY name ASC"; //

        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

29
30
31
32
33
34
35
36
37
38
39
40
public class OracleOutputVisitorTest_delete extends TestCase {

    public void test_0() throws Exception {
        String sql = "DELETE FROM employee where id = 3";

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

        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 class OracleLockTableTest2 extends OracleTest {

    public void test_0() throws Exception {
        String sql = "LOCK TABLE employees@remote    IN SHARE MODE";

        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

28
29
30
31
32
33
34
35
36
37
38
39
public class OracleSchemaStatVisitorTest_Subquery2 extends TestCase {

    public void test_0() throws Exception {
        String sql = "SELECT a.id, a.name, b.name groupName FROM (select id, name, groupId from users WHERE ROWNUM < 10) a inner join groups b on a.groupId = b.id";

        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

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

27
28
29
30
31
32
33
34
35
36
37
38
public class OracleSelectTest1 extends OracleTest {

    public void test_0() throws Exception {
        String sql = "SELECT employees_seq.currval     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

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

6
7
8
9
10
11
12
13
14
import com.alibaba.druid.sql.dialect.oracle.parser.OracleStatementParser;

public class Issue_685 extends TestCase {

    public void test_for_issue() throws Exception {
        OracleStatementParser parser = new OracleStatementParser("select upper(*) from aa order by now()");
        SQLStatement st = parser.parseStatement();
        st.toString();
    }
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.