e302. inserting a varray value into an oracle table.txt

来自「这里面包含了一百多个JAVA源文件」· 文本 代码 · 共 11 行

This example inserts a row with a VARRAY as defined in e301 Creating a VARRAY Type in an Oracle Database. 
    try {
        // 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) {
    }