Insert and update statements
- Last Updated: September 29, 2018
- 1 minute read
- DataDirect Connectors
- JDBC
- Oracle Database 6.0
- 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 <>.