Insert and Update Statements
- Last Updated: May 15, 2020
- 1 minute read
- DataDirect Connectors
- JDBC
- IBM Db2 5.1
- MySQL 5.1
- Progress OpenEdge 5.1
- SAP Sybase 5.1
- Documentation
The Oracle driver supports returning parameter metadata for the following forms of Insert and Update statements:
-
INSERT INTO foo VALUES (?, ?, ?) -
INSERT INTO foo (col1, col2, col3) VALUES (?, ?, ?) -
UPDATE foo SET col1=?, col2=?, col3=? WHERE col1 operator ? [{AND | OR} col2 operator ?]
where operator is any of the following SQL operators: =, <, >, <=, >=, and <>.