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 Sales Cloud User's Guide 6.0.0 Release

Supported SQL functionality

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 Sales Cloud Driver
    • What's New in this Release?
    • Requirements
    • Driver and DataSource classes
    • Connection URL
    • Version string information
    • Connection properties and configuration options
    • Data types
      • getTypeInfo()
    • SQL escape sequences
      • Supported scalar functions
    • Mapping objects to tables
    • DataDirect tools
    • Troubleshooting
    • Additional information
    • Contacting Technical Support
  • Getting started
    • Driver and DataSource classes
    • Connecting using the DriverManager
      • Setting the class path
      • Passing the connection URL
      • Testing the connection
    • Connecting using data sources
      • How data sources are implemented
      • Creating data sources
      • Calling a DataSource in an application
  • Using the driver
    • Connecting from an application
      • Driver and DataSource classes
      • Connecting using the DriverManager
        • Setting the class path
        • Passing the connection URL
        • Testing the connection
      • Connecting using data sources
        • How data sources are implemented
        • Creating data sources
        • Calling a DataSource in an application
    • Using connection properties
      • Required properties
      • Mapping properties
      • Web service properties
      • Proxy server properties
      • Additional properties
    • Proxy server support
    • Unicode support
    • Data encryption
      • FIPS (Federal Information Processing Standard)
    • Catalog Tables
      • SYSTEM_REMOTE_SESSIONS catalog table
      • SYSTEM_SESSIONS catalog table
    • Identifiers
    • Timeouts
    • Scrollable cursors
    • Parameter metadata support
    • ResultSet metadata support
    • Error handling
    • Rowset support
  • Connection property descriptions
    • ConfigOptions
      • APIVersion (configuration option)
    • CreateMap
    • LogConfigFile
    • Password
    • ProxyHost
    • ProxyPassword
    • ProxyPort
    • ProxyUser
    • SchemaMap
    • ServerName
    • SpyAttributes
    • User
    • WSFetchSize
    • WSRetryCount
    • WSTimeout
  • Supported SQL functionality
    • Alter Session (EXT)
    • Refresh Map (EXT)
    • 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 and 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

Supported SQL functionality

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
Print
  • Last Updated: October 20, 2017
  • 1 minute read
    • DataDirect Connectors
    • JDBC
    • Oracle Sales Cloud 6.0
    • Documentation

The driver provides support for SQL statements and extensions described in this section. SQL extensions are denoted by an (EXT) in the topic title.

Contents
  • Alter Session (EXT)
  • Refresh Map (EXT)
  • Select
  • SQL expressions
  • Subqueries
TitleResults for “How to create a CRG?”Also Available inAlert