Examples of OracleExtractExpr

Examples of com.alibaba.druid.sql.dialect.oracle.ast.expr.OracleExtractExpr

107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
                String alias = '"' + lexer.stringVal() + '"';
                lexer.nextToken();
                return primaryRest(new SQLIdentifierExpr(alias));
            case EXTRACT:
                lexer.nextToken();
                OracleExtractExpr extract = new OracleExtractExpr();

                accept(Token.LPAREN);

                extract.setUnit(OracleDateTimeUnit.valueOf(lexer.stringVal()));
                lexer.nextToken();

                accept(Token.FROM);

                extract.setFrom(expr());

                accept(Token.RPAREN);

                return primaryRest(extract);
            case TIMESTAMP:
View Full Code Here

Examples of com.alibaba.druid.sql.dialect.oracle.ast.expr.OracleExtractExpr

316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
                String alias = '"' + lexer.stringVal() + '"';
                lexer.nextToken();
                return primaryRest(new SQLIdentifierExpr(alias));
            case EXTRACT:
                lexer.nextToken();
                OracleExtractExpr extract = new OracleExtractExpr();

                accept(Token.LPAREN);

                extract.setUnit(OracleDateTimeUnit.valueOf(lexer.stringVal().toUpperCase()));
                lexer.nextToken();

                accept(Token.FROM);

                extract.setFrom(expr());

                accept(Token.RPAREN);

                return primaryRest(extract);
            case BINARY_FLOAT:
View Full Code Here

Examples of com.alibaba.druid.sql.dialect.oracle.ast.expr.OracleExtractExpr

115
116
117
118
119
120
121
122
123
124
125
        new OraclePLSQLCommitStatement().accept(adapter);
        new OracleAnalytic().accept(adapter);
        new OracleAnalyticWindowing().accept(adapter);
        new OracleDateExpr().accept(adapter);
        new OracleDbLinkExpr().accept(adapter);
        new OracleExtractExpr().accept(adapter);
        new OracleSelectForUpdate().accept(adapter);
        new OracleSelectHierachicalQueryClause().accept(adapter);
        new OracleSelectPivot.Item().accept(adapter);
        new OracleSelectPivot().accept(adapter);
        new CheckOption().accept(adapter);
View Full Code Here

Examples of com.alibaba.druid.sql.dialect.oracle.ast.expr.OracleExtractExpr

322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
                String alias = '"' + lexer.stringVal() + '"';
                lexer.nextToken();
                return primaryRest(new SQLIdentifierExpr(alias));
            case EXTRACT:
                lexer.nextToken();
                OracleExtractExpr extract = new OracleExtractExpr();

                accept(Token.LPAREN);

                extract.setUnit(OracleDateTimeUnit.valueOf(lexer.stringVal().toUpperCase()));
                lexer.nextToken();

                accept(Token.FROM);

                extract.setFrom(expr());

                accept(Token.RPAREN);

                return primaryRest(extract);
            case BINARY_FLOAT:
View Full Code Here

Examples of com.alibaba.druid.sql.dialect.oracle.ast.expr.OracleExtractExpr

10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
public class EqualTest_extract_oracle extends TestCase {

    public void test_exits() throws Exception {
        String sql = "EXTRACT(MONTH FROM x)";
        String sql_c = "EXTRACT(MONTH FROM 7)";
        OracleExtractExpr exprA, exprB, exprC;
        {
            OracleExprParser parser = new OracleExprParser(sql);
            exprA = (OracleExtractExpr) parser.expr();
        }
        {
            OracleExprParser parser = new OracleExprParser(sql);
            exprB = (OracleExtractExpr) parser.expr();
        }
        {
            OracleExprParser parser = new OracleExprParser(sql_c);
            exprC = (OracleExtractExpr) parser.expr();
        }
        Assert.assertEquals(exprA, exprB);
        Assert.assertNotEquals(exprA, exprC);
        Assert.assertTrue(exprA.equals(exprA));
        Assert.assertFalse(exprA.equals(new Object()));
        Assert.assertEquals(exprA.hashCode(), exprB.hashCode());
       
        Assert.assertEquals(new OracleExtractExpr(), new OracleExtractExpr());
        Assert.assertEquals(new OracleExtractExpr().hashCode(), new OracleExtractExpr().hashCode());
    }
View Full Code Here

Examples of com.alibaba.druid.sql.dialect.oracle.ast.expr.OracleExtractExpr

167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
                String alias = '"' + lexer.stringVal() + '"';
                lexer.nextToken();
                return primaryRest(new SQLIdentifierExpr(alias));
            case EXTRACT:
                lexer.nextToken();
                OracleExtractExpr extract = new OracleExtractExpr();

                accept(Token.LPAREN);

                extract.setUnit(OracleDateTimeUnit.valueOf(lexer.stringVal().toUpperCase()));
                lexer.nextToken();

                accept(Token.FROM);

                extract.setFrom(expr());

                accept(Token.RPAREN);

                return primaryRest(extract);
            case BINARY_FLOAT:
View Full Code Here

Examples of com.alibaba.druid.sql.dialect.oracle.ast.expr.OracleExtractExpr

316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
                String alias = '"' + lexer.stringVal() + '"';
                lexer.nextToken();
                return primaryRest(new SQLIdentifierExpr(alias));
            case EXTRACT:
                lexer.nextToken();
                OracleExtractExpr extract = new OracleExtractExpr();

                accept(Token.LPAREN);

                extract.setUnit(OracleDateTimeUnit.valueOf(lexer.stringVal().toUpperCase()));
                lexer.nextToken();

                accept(Token.FROM);

                extract.setFrom(expr());

                accept(Token.RPAREN);

                return primaryRest(extract);
            case BINARY_FLOAT:
View Full Code Here

Examples of com.alibaba.druid.sql.dialect.oracle.ast.expr.OracleExtractExpr

318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
                String alias = '"' + lexer.stringVal() + '"';
                lexer.nextToken();
                return primaryRest(new SQLIdentifierExpr(alias));
            case EXTRACT:
                lexer.nextToken();
                OracleExtractExpr extract = new OracleExtractExpr();

                accept(Token.LPAREN);

                extract.setUnit(OracleDateTimeUnit.valueOf(lexer.stringVal().toUpperCase()));
                lexer.nextToken();

                accept(Token.FROM);

                extract.setFrom(expr());

                accept(Token.RPAREN);

                return primaryRest(extract);
            case BINARY_FLOAT:
View Full Code Here

Examples of com.alibaba.druid.sql.dialect.oracle.ast.expr.OracleExtractExpr

278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
                String alias = '"' + lexer.stringVal() + '"';
                lexer.nextToken();
                return primaryRest(new SQLIdentifierExpr(alias));
            case EXTRACT:
                lexer.nextToken();
                OracleExtractExpr extract = new OracleExtractExpr();

                accept(Token.LPAREN);

                extract.setUnit(OracleDateTimeUnit.valueOf(lexer.stringVal().toUpperCase()));
                lexer.nextToken();

                accept(Token.FROM);

                extract.setFrom(expr());

                accept(Token.RPAREN);

                return primaryRest(extract);
            case BINARY_FLOAT:
View Full Code Here

Examples of com.alibaba.druid.sql.dialect.oracle.ast.expr.OracleExtractExpr

319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
                String alias = '"' + lexer.stringVal() + '"';
                lexer.nextToken();
                return primaryRest(new SQLIdentifierExpr(alias));
            case EXTRACT:
                lexer.nextToken();
                OracleExtractExpr extract = new OracleExtractExpr();

                accept(Token.LPAREN);

                extract.setUnit(OracleDateTimeUnit.valueOf(lexer.stringVal().toUpperCase()));
                lexer.nextToken();

                accept(Token.FROM);

                extract.setFrom(expr());

                accept(Token.RPAREN);

                return primaryRest(extract);
            case BINARY_FLOAT:
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.