Inserting a VARRAY Value into an Oracle Table - Java JDBC

Java examples for JDBC:Oracle

  1. HOME
  2. Java
  3. JDBC
  4. Oracle

Description

Inserting a VARRAY Value into an Oracle Table

Demo Code

import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Statement;

public class Main {
  public static void main(String[] args) {

    Connection connection = null;
    try {/*from w  w w  .  ja  va 2 s .  c o m*/
      // Create a statement
      Statement stmt = connection.createStatement();

      // Insert a row with an array of two values
      stmt.execute("INSERT INTO varray_table VALUES(number_varray(123, 234))");
    } catch (SQLException e) {
    }
  }
}

Related Tutorials