Skip to content

Latest commit

 

History

History
50 lines (44 loc) · 4.35 KB

OracleDialect.md

File metadata and controls

50 lines (44 loc) · 4.35 KB

OracleDialect class

namespace: Serenity.Data   assemblySerenity.Net.Data

Oracle dialect

public class OracleDialect : ISqlDialect

Public Members

name description
OracleDialect() The default constructor.
virtual CanUseOffsetFetch { get; } Gets a value indicating whether the server supports OFFSET FETCH.
virtual CanUseRowNumber { get; } Gets a value indicating whether the server supports ROWNUMBER.
virtual CanUseSkipKeyword { get; } Gets a value indicating whether the server supports SKIP keyword (or a variation of it).
virtual CloseQuote { get; } Gets the close quote character for quoting identifiers.
virtual ConcatOperator { get; } Gets the CONCAT operator keyword.
virtual DateFormat { get; } Gets the date format.
virtual DateTimeFormat { get; } Gets the date time format.
virtual IsLikeCaseSensitive { get; } Gets a value indicating whether the LIKE operator is case sensitive.
virtual MultipleResultsets { get; } Gets a value indicating whether the server supports multiple resultsets.
virtual NeedsBoolWorkaround { get; } Gets a value indicating whether the server needs a workaround to handle Boolean values false/true.
virtual NeedsExecuteBlockStatement { get; } Gets a value indicating whether the server needs EXECUTE BLOCK statement.
virtual OffsetFetchFormat { get; } Gets the format for OFFSET FETCH statements.
virtual OffsetFormat { get; } Gets the format for OFFSET only statements.
virtual OpenQuote { get; } Gets the open quote character for quoting identifiers.
virtual ParameterPrefix { get; } Gets the parameter prefix character.
virtual ScopeIdentityExpression { get; } Gets the SCOPE IDENTITY expression.
virtual ServerType { get; } Gets the type of the server.
virtual SkipKeyword { get; } Gets the skip keyword.
virtual TakeKeyword { get; } Gets the take keyword.
virtual TimeFormat { get; } Gets the time format.
virtual UseDateTime2 { get; } Gets a value indicating whether use datetime2 type.
virtual UseReturningIdentity { get; } Gets a value indicating whether to use returning identity.
virtual UseReturningIntoVar { get; } Gets a value indicating whether use returning into variable.
virtual UseRowNum { get; } Gets a value indicating whether ROWNUM.
virtual UseScopeIdentity { get; } Gets a value indicating whether to use scope identity.
virtual UseTakeAtEnd { get; } Gets a value indicating whether to use TAKE at end.
virtual QuoteColumnAlias(…) Quotes the column alias. This usually calls QuoteIdentifier except for Oracle.
virtual QuoteIdentifier(…) Quotes the identifier.
virtual QuoteUnicodeString(…) Quotes the unicode string.
UnionKeyword(…) Gets the union keyword for specified union type.
static readonly Instance The shared instance of OracleDialect.

See Also