public class

OracleDialect

extends Oracle9Dialect
java.lang.Object
   ↳ org.hibernate.dialect.Dialect
     ↳ org.hibernate.dialect.Oracle9Dialect
       ↳ org.hibernate.dialect.OracleDialect

This class is deprecated.
Use Oracle8iDialect instead.

Class Overview

An SQL dialect for Oracle, compatible with Oracle 8.

Summary

[Expand]
Inherited Constants
From class org.hibernate.dialect.Dialect
Public Constructors
OracleDialect()
Public Methods
CaseFragment createCaseFragment()
Create a CaseFragment strategy responsible for handling this dialect's variations in how CASE statements are handled.
JoinFragment createOuterJoinFragment()
Create a JoinFragment strategy responsible for handling this dialect's variations in how joins are handled.
String getCurrentTimestampSQLFunctionName()
The name of the database-specific SQL function for retrieving the current timestamp.
String getCurrentTimestampSelectString()
Retrieve the command used to retrieve the current timestamp from the database.
String getLimitString(String sql, boolean hasOffset)
Apply s limit clause to the query.
String getSelectClauseNullString(int sqlType)
Given a java.sql.Types type code, determine an appropriate null value to use in a select clause.
[Expand]
Inherited Methods
From class org.hibernate.dialect.Oracle9Dialect
From class org.hibernate.dialect.Dialect
From class java.lang.Object

Public Constructors

public OracleDialect ()

Public Methods

public CaseFragment createCaseFragment ()

Create a CaseFragment strategy responsible for handling this dialect's variations in how CASE statements are handled.

Returns

public JoinFragment createOuterJoinFragment ()

Create a JoinFragment strategy responsible for handling this dialect's variations in how joins are handled.

Returns

public String getCurrentTimestampSQLFunctionName ()

The name of the database-specific SQL function for retrieving the current timestamp.

Returns
  • The function name.

public String getCurrentTimestampSelectString ()

Retrieve the command used to retrieve the current timestamp from the database.

Returns
  • The command.

public String getLimitString (String sql, boolean hasOffset)

Apply s limit clause to the query.

Typically dialects utilize variable limit clauses when they support limits. Thus, when building the select command we do not actually need to know the limit or the offest since we will just be using placeholders.

Here we do still pass along whether or not an offset was specified so that dialects not supporting offsets can generate proper exceptions. In general, dialects will override one or the other of this method and getLimitString(String, int, int).

Parameters
sql The query to which to apply the limit.
hasOffset Is the query requesting an offset?
Returns
  • the modified SQL

public String getSelectClauseNullString (int sqlType)

Given a java.sql.Types type code, determine an appropriate null value to use in a select clause.

One thing to consider here is that certain databases might require proper casting for the nulls here since the select here will be part of a UNION/UNION ALL.

Parameters
sqlType The java.sql.Types type code.
Returns
  • The appropriate select clause value fragment.