Examples of com.alibaba.druid.sql.dialect.oracle.ast.clause.OraclePartitionByRangeClause

Package com.alibaba.druid.sql.dialect.oracle.ast.clause

Examples of com.alibaba.druid.sql.dialect.oracle.ast.clause.OraclePartitionByRangeClause

com.alibaba.druid.sql.dialect.oracle.ast.clause.OraclePartitionByRangeClause

                accept(Token.BY);


                if (identifierEquals("RANGE")) {
                    lexer.nextToken();
                    accept(Token.LPAREN);
                    OraclePartitionByRangeClause clause = new OraclePartitionByRangeClause();
                    for (;;) {
                        SQLName column = this.exprParser.name();
                        clause.getColumns().add(column);
                        
                        if (lexer.token() == Token.COMMA) {
                            lexer.nextToken();
                            continue;
                        }
                        
                        break;
                    }
                    accept(Token.RPAREN);
                    
                    if (identifierEquals("INTERVAL")) {
                        lexer.nextToken();
                        clause.setInterval(this.exprParser.expr());
                    }
                    
                    if (identifierEquals("STORE")) {
                        lexer.nextToken();
                        accept(Token.IN);
                        accept(Token.LPAREN);
                        for (;;) {
                            SQLName tablespace = this.exprParser.name();
                            clause.getStoreIn().add(tablespace);
                            
                            if (lexer.token() == Token.COMMA) {
                                lexer.nextToken();
                                continue;
                            }
                            
                            break;
                        }
                        accept(Token.RPAREN);
                    }
                    
                    accept(Token.LPAREN);
                    
                    for (;;) {
                        acceptIdentifier("PARTITION");
                        OracleRangeValuesClause range = new OracleRangeValuesClause();
                        range.setName(this.exprParser.name());
                        
                        accept(Token.VALUES);
                        acceptIdentifier("LESS");
                        acceptIdentifier("THAN");
                        
                        accept(Token.LPAREN);
                        for (;;) {
                            SQLExpr rangeValue = this.exprParser.expr();
                            range.getValues().add(rangeValue);
                            
                            if (lexer.token() == Token.COMMA) {
                                lexer.nextToken();
                                continue;
                            }
                            
                            break;
                        }
                        accept(Token.RPAREN);
                        
                        clause.getRanges().add(range);
                        
                        if (lexer.token() == Token.COMMA) {
                            lexer.nextToken();
                            continue;
                        }

View Full Code Here

                accept(Token.BY);


                if (identifierEquals("RANGE")) {
                    lexer.nextToken();
                    accept(Token.LPAREN);
                    OraclePartitionByRangeClause clause = new OraclePartitionByRangeClause();
                    for (;;) {
                        SQLName column = this.exprParser.name();
                        clause.getColumns().add(column);
                        
                        if (lexer.token() == Token.COMMA) {
                            lexer.nextToken();
                            continue;
                        }
                        
                        break;
                    }
                    accept(Token.RPAREN);
                    
                    if (identifierEquals("INTERVAL")) {
                        lexer.nextToken();
                        clause.setInterval(this.exprParser.expr());
                    }
                    
                    if (identifierEquals("STORE")) {
                        lexer.nextToken();
                        accept(Token.IN);
                        accept(Token.LPAREN);
                        for (;;) {
                            SQLName tablespace = this.exprParser.name();
                            clause.getStoreIn().add(tablespace);
                            
                            if (lexer.token() == Token.COMMA) {
                                lexer.nextToken();
                                continue;
                            }
                            
                            break;
                        }
                        accept(Token.RPAREN);
                    }
                    
                    accept(Token.LPAREN);
                    
                    for (;;) {
                        acceptIdentifier("PARTITION");
                        OracleRangeValuesClause range = new OracleRangeValuesClause();
                        range.setName(this.exprParser.name());
                        
                        accept(Token.VALUES);
                        acceptIdentifier("LESS");
                        acceptIdentifier("THAN");
                        
                        accept(Token.LPAREN);
                        for (;;) {
                            SQLExpr rangeValue = this.exprParser.expr();
                            range.getValues().add(rangeValue);
                            
                            if (lexer.token() == Token.COMMA) {
                                lexer.nextToken();
                                continue;
                            }
                            
                            break;
                        }
                        accept(Token.RPAREN);
                        
                        clause.getRanges().add(range);
                        
                        if (lexer.token() == Token.COMMA) {
                            lexer.nextToken();
                            continue;
                        }

View Full Code Here

                accept(Token.BY);


                if (identifierEquals("RANGE")) {
                    lexer.nextToken();
                    accept(Token.LPAREN);
                    OraclePartitionByRangeClause clause = new OraclePartitionByRangeClause();
                    for (;;) {
                        SQLName column = this.exprParser.name();
                        clause.getColumns().add(column);


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


                        break;
                    }
                    accept(Token.RPAREN);


                    if (identifierEquals("INTERVAL")) {
                        lexer.nextToken();
                        clause.setInterval(this.exprParser.expr());
                    }


                    if (lexer.token() == Token.STORE) {
                        lexer.nextToken();
                        accept(Token.IN);
                        accept(Token.LPAREN);
                        for (;;) {
                            SQLName tablespace = this.exprParser.name();
                            clause.getStoreIn().add(tablespace);


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


                            break;
                        }
                        accept(Token.RPAREN);
                    }


                    accept(Token.LPAREN);


                    for (;;) {
                        acceptIdentifier("PARTITION");
                        OracleRangeValuesClause range = new OracleRangeValuesClause();
                        range.setName(this.exprParser.name());


                        accept(Token.VALUES);
                        acceptIdentifier("LESS");
                        acceptIdentifier("THAN");


                        accept(Token.LPAREN);
                        for (;;) {
                            SQLExpr rangeValue = this.exprParser.expr();
                            range.getValues().add(rangeValue);


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


                            break;
                        }
                        accept(Token.RPAREN);


                        clause.getRanges().add(range);


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

View Full Code Here

        new OracleFileSpecification().accept(adapter);
        new OracleAlterTablespaceAddDataFile().accept(adapter);
        new OracleAlterTablespaceStatement().accept(adapter);
        new OracleCreateSequenceStatement().accept(adapter);
        new OracleRangeValuesClause().accept(adapter);
        new OraclePartitionByRangeClause().accept(adapter);
        new OracleLoopStatement().accept(adapter);
        new OracleIntervalExpr().accept(adapter);
        new OracleDeleteStatement().accept(adapter);
        new OracleUpdateStatement().accept(adapter);
        new SampleClause().accept(adapter);

View Full Code Here

                accept(Token.BY);


                if (identifierEquals("RANGE")) {
                    lexer.nextToken();
                    accept(Token.LPAREN);
                    OraclePartitionByRangeClause clause = new OraclePartitionByRangeClause();
                    for (;;) {
                        SQLName column = this.exprParser.name();
                        clause.getColumns().add(column);
                        
                        if (lexer.token() == Token.COMMA) {
                            lexer.nextToken();
                            continue;
                        }
                        
                        break;
                    }
                    accept(Token.RPAREN);
                    
                    if (identifierEquals("INTERVAL")) {
                        lexer.nextToken();
                        clause.setInterval(this.exprParser.expr());
                    }
                    
                    if (identifierEquals("STORE")) {
                        lexer.nextToken();
                        accept(Token.IN);
                        accept(Token.LPAREN);
                        for (;;) {
                            SQLName tablespace = this.exprParser.name();
                            clause.getStoreIn().add(tablespace);
                            
                            if (lexer.token() == Token.COMMA) {
                                lexer.nextToken();
                                continue;
                            }
                            
                            break;
                        }
                        accept(Token.RPAREN);
                    }
                    
                    accept(Token.LPAREN);
                    
                    for (;;) {
                        acceptIdentifier("PARTITION");
                        OracleRangeValuesClause range = new OracleRangeValuesClause();
                        range.setName(this.exprParser.name());
                        
                        accept(Token.VALUES);
                        acceptIdentifier("LESS");
                        acceptIdentifier("THAN");
                        
                        accept(Token.LPAREN);
                        for (;;) {
                            SQLExpr rangeValue = this.exprParser.expr();
                            range.getValues().add(rangeValue);
                            
                            if (lexer.token() == Token.COMMA) {
                                lexer.nextToken();
                                continue;
                            }
                            
                            break;
                        }
                        accept(Token.RPAREN);
                        
                        clause.getRanges().add(range);
                        
                        if (lexer.token() == Token.COMMA) {
                            lexer.nextToken();
                            continue;
                        }

View Full Code Here

TOP

Related Classes of com.alibaba.druid.sql.dialect.oracle.ast.clause.OraclePartitionByRangeClause

com.alibaba.druid.bvt.sql.oracle.visitor.OracleASTVisitorAdapterTest

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

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.