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çaisItaliano (Italy)Português (Brasil)日本語Русский (Russia)中文 (简体) (China)中文 (繁體, 台灣) (Taiwan)ar-AR
  • Login

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

Supported SQL Statements and Extensions

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
    • Installing and setting up the driver
    • Driver and DataSource classes
    • Connection URL examples
    • Data types
      • getTypeInfo()
    • DataDirect tools
    • Troubleshooting
    • Contacting Technical Support
  • Tutorials
    • Interactive SQL
    • Tableau
    • DbVisualizer
      • Adding a driver
      • Connecting and executing SQL statements
  • Configuring and connecting
    • Setting the classpath
    • Connecting using the JDBC Driver Manager
      • Passing the connection URL
      • Generating connection URLs with the Configuration Manager
      • Testing connections and queries
    • Connecting using data sources
      • How data sources are implemented
      • Creating data sources
        • Example data source
      • Calling a data source in an application
      • Testing a data source connection
    • Authentication
      • User ID/password authentication
    • Data Encryption
      • FIPS (Federal Information Processing Standard)
    • Performance considerations
  • Additional features and functionality
    • Views and Local Tables
    • Client-Side Caches
      • Creating a Cache
      • Modifying a Cache Definition
      • Disabling and Enabling a Cache
      • Refreshing Cache Data
      • Dropping a Cache
      • Caching 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
      • Insert and Update Statements
      • Select Statements
    • Unicode support
    • Error Handling
    • Timeouts
    • Scrollable Cursors
    • Large Objects (LOBs)
    • "Poor Performing Query" Error Message
    • Failover Support
    • Statement pooling
    • Connection pooling
    • Tracking JDBC calls with DataDirect Spy
      • Enabling DataDirect Spy
        • Using the JDBC DriverManager
        • Using JDBC Data Sources
        • DataDirect Spy attributes
  • Connection property descriptions
    • AuditColumns
    • AuthenticationMethod
    • ConnectionRetryCount
    • ConnectionRetryDelay
    • ConvertNull
    • CreateMap
    • CustomSuffix
    • DebugRecord
    • EnableAccessRequestHeader
    • EnablePagingWithOrderByID
    • FetchSize
    • ImportStatementPool
    • InitializationString
    • InsensitiveResultSetBufferSize
    • JavaDoubleToString
    • KeywordConflictSuffix
    • LogConfigFile
    • LoginHost
    • LoginTimeout
    • ManagedObjects
    • MapCustomNamedIDFields
    • MapSystemColumnNames
    • MaxPooledStatements
    • NamedIDBehavior
    • OracleServiceCloudDatabase
    • Password
    • ProxyHost
    • ProxyPassword
    • ProxyPort
    • ProxyUser
    • ReadOnly
    • RegisterStatementPoolMonitorMBean
    • SchemaMap
    • ServerName
    • SOAPAppIDString
    • SpyAttributes
    • StmtCallLimit
    • StmtCallLimitBehavior
    • TransactionMode
    • UppercaseIdentifiers
    • User
    • WSCompressData
    • WSFetchSize
    • WSPoolSize
    • 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
    • Create Cache (EXT)
      • Relational Caches
      • Referencing Clause
      • 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
    • Delete
    • Drop Cache (EXT)
    • Drop Index
    • Drop Sequence
    • Drop Table
    • Drop View
    • Explain Plan
    • Insert
      • Specifying an External ID Column
    • Refresh Cache (EXT)
    • Refresh Map (EXT)
    • Select
      • Select Clause
        • Aggregate Functions
        • From Clause
          • 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
    • Update
    • 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

Supported SQL Statements and Extensions

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
Print
  • Last Updated: April 26, 2018
  • 1 minute read
    • DataDirect Connectors
    • JDBC
    • Documentation

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

Contents
  • Alter Cache (EXT)
  • Alter Index
  • Alter Sequence
  • Alter Session (EXT)
  • Alter Table
  • Create Cache (EXT)
  • Create Index
  • Create Sequence
  • Create Table
  • Create View
  • Delete
  • Drop Cache (EXT)
  • Drop Index
  • Drop Sequence
  • Drop Table
  • Drop View
  • Explain Plan
  • Insert
  • Refresh Cache (EXT)
  • Refresh Map (EXT)
  • Select
  • Update
  • SQL Expressions
  • Subqueries
Alert