Skip to main contentSkip to search
Powered by Zoomin Software. For more details please contactZoomin
Progress DocumentationProgress Documentation
Progress Documentation
  • Home
  • Home
  • EnglishČeštinaDeutsch (Germany)Español (Spain)Français (France)Italiano (Italy)Português (Brasil)日本語Русский (Russia)中文 (简体) (China)中文 (繁體, 台灣) (Taiwan)ar-AR
  • Login

Progress DataDirect for JDBC for Oracle Service Cloud Driver User's Guide Release 5.1.4

Operators

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
Print
Table of Contents
  • Welcome to the Progress DataDirect for JDBC for Oracle Service Cloud Driver
    • What's New in this Release?
    • Requirements
    • Data Source and Driver Classes
    • Connection Properties
    • Version String Information
    • Data Types
      • getTypeInfo()
    • Mapping Objects to Tables
      • Standard and Custom Objects
      • Primary Objects, Sub-objects, and Lists of Sub-objects
      • Many-to-many Relationships
    • DataDirect tools
    • Troubleshooting
    • Contacting Technical Support
  • Getting started
    • Connecting with the JDBC Driver Manager
    • Setting the Classpath
    • Passing the Connection URL
    • Testing the Connection
  • Using the driver
    • Required permissions for Java SE with the standard Security Manager enabled
      • Permissions for establishing connections
      • Granting access to Java properties
      • Granting access to temporary files
    • Connecting from an Application
      • Connecting Using the JDBC Driver Manager
        • Registering the Driver
        • Passing Connection URLs
      • Connecting Using Data Sources
        • How Data Sources Are Implemented
        • Creating Data Sources
        • Calling a Data Source in an Application
      • Testing the Connection
    • Connecting Through a Proxy Server
    • Using Connection Properties
      • Required Properties
      • Embedded Database Properties
      • Proxy Server Properties
      • Web Service Properties
      • Statement Pooling Properties
      • Additional Properties
    • Performance Considerations
    • Using the Database Configuration File
      • <Database>
      • <User>
      • <UseSchema>
      • <Schema>
      • <ConfigOptions>
      • <SessionOptions>
    • Data Encryption
      • FIPS (Federal Information Processing Standard)
    • Views and Remote/Local Tables
    • Client-Side Caches
      • Creating a Cache
      • Modifying a Cache Definition
      • Disabling and Enabling a Cache
      • Refreshing Cache Data
      • Dropping a Cache
      • Cache MetaData
    • Catalog Tables
      • SYSTEM_CACHES Catalog Table
      • SYSTEM_CACHE_REFERENCES Catalog Table
      • SYSTEM_REMOTE_SESSIONS Catalog Table
      • SYSTEM_SESSIONS Catalog Table
    • Reports
    • Identifiers
    • IP Addresses
    • Auto-Generated Keys Support
    • Rowset Support
    • ResultSet MetaData Support
    • Parameter Metadata Support
    • Unicode support
    • Error Handling
    • Timeouts
    • Scrollable Cursors
    • Large Objects (LOBs)
    • "Poor Performing Query" Error Message
  • Connection Property Descriptions
    • ConfigOptions
    • ConvertNull
    • CreateDB
    • DatabaseName
    • EnableAccessRequestHeader
    • EnablePagingWithOrderById
    • FetchSize
    • ImportStatementPool
    • InitializationString
    • InsensitiveResultSetBufferSize
    • InterfaceName
    • JavaDoubleToString
    • LogConfigFile
    • LoginHost
    • LoginTimeout
    • ManagedObjects
    • MaxPooledStatements
    • OracleServiceCloudDatabase
    • Password
    • ProxyHost
    • ProxyPassword
    • ProxyPort
    • ProxyUser
    • RefreshDirtyCache
    • RegisterStatementPoolMonitorMBean
    • SpyAttributes
    • StmtCallLimit
    • StmtCallLimitBehavior
    • TransactionMode
    • User
    • WSCompressData
    • WSFetchSize
    • WSRetryCount
    • WSTimeout
  • Supported SQL Statements and Extensions
    • Alter Cache (EXT)
    • Alter Index
    • Alter Sequence
    • Alter Session (EXT)
    • Alter Table
      • Add Clause: Columns
      • Add Clause: Constraints
      • Drop Clause: Columns
      • Drop Clause: Constraints
      • Rename Clause
    • Checkpoint
    • Create Cache (EXT)
      • Refresh Interval Clause
      • Initial Check Clause
      • Persist Clause
      • Enabled Clause
      • Call Limit Clause
      • Filter Clause
    • Create Index
    • Create Sequence
      • Next Value For Clause
    • Create Table
      • Column Definition for Local Tables
      • Constraint Definition for Local Tables
    • Create View
    • Drop Cache (EXT)
    • Drop Index
    • Drop Sequence
    • Drop Table
    • Drop View
    • Explain Plan
    • Refresh Cache (EXT)
    • Set Checkpoint Defrag
    • Set Logsize
    • Select
      • Select Clause
        • Aggregate Functions
        • From Clause
          • Outer Join Escape Sequences
          • Join in a From Clause
          • Subquery in a From Clause
        • Where Clause
        • Group By Clause
        • Having Clause
        • Union Operator
        • Intersect Operator
        • Except and Minus Operators
        • Order By Clause
        • Limit Clause
    • SQL Expressions
      • Column Names
      • Literals
        • Character String Literals
        • Numeric Literals
        • Binary Literals
        • Date/Time Literals
        • Integer Literals
      • Operators
        • Unary Operator
        • Binary Operator
        • Arithmetic Operators
        • Concatenation Operator
        • Comparison Operators
        • Logical Operators
        • Operator Precedence
      • Functions
      • Conditions
    • Subqueries
      • IN Predicate
      • EXISTS Predicate
      • UNIQUE Predicate
      • Correlated Subqueries
  • Copyright
Table of Contents

Operators

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
Print
  • Last Updated: June 14, 2020
  • 1 minute read
    • DataDirect Connectors
    • JDBC
    • Oracle Service Cloud 5.1
    • Documentation

This section describes the operators that can be used in SQL expressions.

Contents
  • Unary Operator
  • Binary Operator
  • Arithmetic Operators
  • Concatenation Operator
  • Comparison Operators
  • Logical Operators
  • Operator Precedence
TitleResults for “How to create a CRG?”Also Available inAlert