net.sf.jkniv.whinstone.jdbc.dialect

Class Oracle12cDialect

java.lang.Object

net.sf.jkniv.sqlegance.dialect.AnsiDialect

net.sf.jkniv.whinstone.jdbc.dialect.OracleDialect

net.sf.jkniv.whinstone.jdbc.dialect.Oracle12cDialect

All Implemented Interfaces:

SqlDialect

public class Oracle12cDialect
extends OracleDialect

Default dialect do Oracle

Limit clause: select name from author LIMIT 1 OFFSET 2 select * from ( select row_.*, rownum rownum_ from (select name from author ) row_ where rownum <= 5) where rownum_ > 15

• Supports limits? true
• Supports limit off set? true
• Supports rownum? true

Since:

0.6.0

Author:

Alisson Gomes

Field Summary

Fields inherited from class net.sf.jkniv.sqlegance.dialect.AnsiDialect

name, patternORDER_BY

Constructor Summary

Constructors

Constructor and Description
Oracle12cDialect()

Method Summary

Methods inherited from class net.sf.jkniv.whinstone.jdbc.dialect.OracleDialect

buildQueryPaging, getMaxOfParameters, getSqlPatternPaging

Methods inherited from class net.sf.jkniv.sqlegance.dialect.AnsiDialect

addFeature, buildQueryCount, buildQueryPaging, countOccurrencesOf, getAccessId, getAccessRevision, getSqlPatternCount, name, setMaxOfParameters, sqlEndsWithOrderBy, sqlEndWithForUpdate, sqlStartWithSelect, sqlStartWithSelectOrDistinct, supportsFeature, supportsParmMark

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

Oracle12cDialect

public Oracle12cDialect()