Examples of OracleSelectQueryBlock

com.alibaba.druid.sql.dialect.oracle.ast.stmt.OracleSelectQueryBlock

Examples of com.alibaba.druid.sql.dialect.oracle.ast.stmt.OracleSelectQueryBlock

            accept(Token.RPAREN);


            return queryRest(select);
        }


        OracleSelectQueryBlock queryBlock = new OracleSelectQueryBlock();
        if (lexer.token() == Token.SELECT) {
            lexer.nextToken();


            parseHints(queryBlock);


            if (lexer.token() == (Token.DISTINCT)) {
                queryBlock.setDistionOption(SQLSetQuantifier.DISTINCT);
                lexer.nextToken();
            } else if (lexer.token() == (Token.UNIQUE)) {
                queryBlock.setDistionOption(SQLSetQuantifier.UNIQUE);
                lexer.nextToken();
            } else if (lexer.token() == (Token.ALL)) {
                queryBlock.setDistionOption(SQLSetQuantifier.ALL);
                lexer.nextToken();
            }


            this.createExprParser().parseHints(queryBlock.getHints());


            parseSelectList(queryBlock);
        }


        parseInto(queryBlock);

View Full Code Here

Examples of com.alibaba.druid.sql.dialect.oracle.ast.stmt.OracleSelectQueryBlock

            return queryRest(select);
        }


        accept(Token.SELECT);


        OracleSelectQueryBlock queryBlock = new OracleSelectQueryBlock();
        parseHints(queryBlock);


        if (lexer.token() == (Token.DISTINCT)) {
            queryBlock.setDistionOption(SQLSetQuantifier.DISTINCT);
            lexer.nextToken();
        } else if (lexer.token() == (Token.UNIQUE)) {
            queryBlock.setDistionOption(SQLSetQuantifier.UNIQUE);
            lexer.nextToken();
        } else if (lexer.token() == (Token.ALL)) {
            queryBlock.setDistionOption(SQLSetQuantifier.ALL);
            lexer.nextToken();
        }


        parseSelectList(queryBlock);

View Full Code Here

Examples of com.alibaba.druid.sql.dialect.oracle.ast.stmt.OracleSelectQueryBlock

        return new OracleOutputVisitor(out, false);
    }


    public SQLSelectQueryBlock explainToSelectSQLObject(MappingEngine engine, String sql) {
        OracleSelectParser selectParser = new OracleSelectParser(sql);
        OracleSelectQueryBlock query = (OracleSelectQueryBlock) selectParser.query();


        return query;
    }

View Full Code Here

Examples of com.alibaba.druid.sql.dialect.oracle.ast.stmt.OracleSelectQueryBlock


    private static String limitOracle(SQLSelect select, String dbType, int offset, int count) {
        SQLSelectQuery query = select.getQuery();


        if (query instanceof SQLSelectQueryBlock) {
            OracleSelectQueryBlock queryBlock = (OracleSelectQueryBlock) query;
            if (queryBlock.getGroupBy() == null && select.getOrderBy() == null && offset <= 0) {
                SQLExpr condition = new SQLBinaryOpExpr(new SQLIdentifierExpr("ROWNUM"), //
                                                        SQLBinaryOperator.LessThanOrEqual, //
                                                        new SQLNumberExpr(count));
                if (queryBlock.getWhere() == null) {
                    queryBlock.setWhere(condition);
                } else {
                    queryBlock.setWhere(new SQLBinaryOpExpr(queryBlock.getWhere(), //
                                                            SQLBinaryOperator.BooleanAnd, //
                                                            condition));
                }


                return SQLUtils.toSQLString(select, dbType);
            }
        }


        OracleSelectQueryBlock countQueryBlock = new OracleSelectQueryBlock();
        countQueryBlock.getSelectList().add(new SQLSelectItem(new SQLPropertyExpr(new SQLIdentifierExpr("XX"), "*")));
        countQueryBlock.getSelectList().add(new SQLSelectItem(new SQLIdentifierExpr("ROWNUM"), "RN"));


        countQueryBlock.setFrom(new SQLSubqueryTableSource(select, "XX"));
        countQueryBlock.setWhere(new SQLBinaryOpExpr(new SQLIdentifierExpr("ROWNUM"), //
                                                     SQLBinaryOperator.LessThanOrEqual, //
                                                     new SQLNumberExpr(count + offset)));
        if (offset <= 0) {
            return SQLUtils.toSQLString(countQueryBlock, dbType);
        }


        OracleSelectQueryBlock offsetQueryBlock = new OracleSelectQueryBlock();
        offsetQueryBlock.getSelectList().add(new SQLSelectItem(new SQLAllColumnExpr()));
        offsetQueryBlock.setFrom(new SQLSubqueryTableSource(new SQLSelect(countQueryBlock), "XXX"));
        offsetQueryBlock.setWhere(new SQLBinaryOpExpr(new SQLIdentifierExpr("RN"), //
                                                      SQLBinaryOperator.GreaterThan, //
                                                      new SQLNumberExpr(offset)));


        return SQLUtils.toSQLString(offsetQueryBlock, dbType);
    }

View Full Code Here

Examples of com.alibaba.druid.sql.dialect.oracle.ast.stmt.OracleSelectQueryBlock

        if (JdbcConstants.H2.equals(dbType)) {
            return new MySqlSelectQueryBlock();
        }


        if (JdbcConstants.ORACLE.equals(dbType)) {
            return new OracleSelectQueryBlock();
        }


        if (JdbcConstants.POSTGRESQL.equals(dbType)) {
            return new PGSelectQueryBlock();
        }

View Full Code Here

Examples of com.alibaba.druid.sql.dialect.oracle.ast.stmt.OracleSelectQueryBlock

            accept(Token.RPAREN);


            return queryRest(select);
        }


        OracleSelectQueryBlock queryBlock = new OracleSelectQueryBlock();
        if (lexer.token() == Token.SELECT) {
            lexer.nextToken();


            parseHints(queryBlock);


            if (lexer.token() == (Token.DISTINCT)) {
                queryBlock.setDistionOption(SQLSetQuantifier.DISTINCT);
                lexer.nextToken();
            } else if (lexer.token() == (Token.UNIQUE)) {
                queryBlock.setDistionOption(SQLSetQuantifier.UNIQUE);
                lexer.nextToken();
            } else if (lexer.token() == (Token.ALL)) {
                queryBlock.setDistionOption(SQLSetQuantifier.ALL);
                lexer.nextToken();
            }


            this.createExprParser().parseHints(queryBlock.getHints());


            parseSelectList(queryBlock);
        }


        parseInto(queryBlock);

View Full Code Here

Examples of com.alibaba.druid.sql.dialect.oracle.ast.stmt.OracleSelectQueryBlock

        return new OracleOutputVisitor(out, false);
    }


    public SQLSelectQueryBlock explainToSelectSQLObject(MappingEngine engine, String sql) {
        OracleSelectParser selectParser = new OracleSelectParser(sql);
        OracleSelectQueryBlock query = (OracleSelectQueryBlock) selectParser.query();


        return query;
    }

View Full Code Here

Examples of com.alibaba.druid.sql.dialect.oracle.ast.stmt.OracleSelectQueryBlock

            accept(Token.RPAREN);


            return queryRest(select);
        }


        OracleSelectQueryBlock queryBlock = new OracleSelectQueryBlock();
        if (lexer.token() == Token.SELECT) {
            lexer.nextToken();


            parseHints(queryBlock);


            if (lexer.token() == (Token.DISTINCT)) {
                queryBlock.setDistionOption(SQLSetQuantifier.DISTINCT);
                lexer.nextToken();
            } else if (lexer.token() == (Token.UNIQUE)) {
                queryBlock.setDistionOption(SQLSetQuantifier.UNIQUE);
                lexer.nextToken();
            } else if (lexer.token() == (Token.ALL)) {
                queryBlock.setDistionOption(SQLSetQuantifier.ALL);
                lexer.nextToken();
            }


            this.exprParser.parseHints(queryBlock.getHints());


            parseSelectList(queryBlock);
        }


        parseInto(queryBlock);

View Full Code Here

Examples of com.alibaba.druid.sql.dialect.oracle.ast.stmt.OracleSelectQueryBlock

            accept(Token.RPAREN);


            return queryRest(select);
        }


        OracleSelectQueryBlock queryBlock = new OracleSelectQueryBlock();
        if (lexer.token() == Token.SELECT) {
            lexer.nextToken();


            if (lexer.token() == Token.COMMENT) {
                lexer.nextToken();
            }


            parseHints(queryBlock);


            if (lexer.token() == (Token.DISTINCT)) {
                queryBlock.setDistionOption(SQLSetQuantifier.DISTINCT);
                lexer.nextToken();
            } else if (lexer.token() == (Token.UNIQUE)) {
                queryBlock.setDistionOption(SQLSetQuantifier.UNIQUE);
                lexer.nextToken();
            } else if (lexer.token() == (Token.ALL)) {
                queryBlock.setDistionOption(SQLSetQuantifier.ALL);
                lexer.nextToken();
            }


            this.exprParser.parseHints(queryBlock.getHints());


            parseSelectList(queryBlock);
        }


        parseInto(queryBlock);

View Full Code Here

Examples of com.alibaba.druid.sql.dialect.oracle.ast.stmt.OracleSelectQueryBlock

            accept(Token.RPAREN);


            return queryRest(select);
        }


        OracleSelectQueryBlock queryBlock = new OracleSelectQueryBlock();
        if (lexer.token() == Token.SELECT) {
            lexer.nextToken();


            parseHints(queryBlock);


            if (lexer.token() == (Token.DISTINCT)) {
                queryBlock.setDistionOption(SQLSetQuantifier.DISTINCT);
                lexer.nextToken();
            } else if (lexer.token() == (Token.UNIQUE)) {
                queryBlock.setDistionOption(SQLSetQuantifier.UNIQUE);
                lexer.nextToken();
            } else if (lexer.token() == (Token.ALL)) {
                queryBlock.setDistionOption(SQLSetQuantifier.ALL);
                lexer.nextToken();
            }


            this.exprParser.parseHints(queryBlock.getHints());


            parseSelectList(queryBlock);
        }


        parseInto(queryBlock);

View Full Code Here

0 1 2 3

TOP

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.