e297. inserting an object value into an oracle table.txt

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

This example inserts a row into a table with a column that contains an OBJECT type. The example uses the table and types created in e296 Creating an OBJECT Type in an Oracle Database. 
    try {
        // Create a statement
        Statement stmt = connection.createStatement();
    
        // Insert a row with values for both the object1 and object2 types
        stmt.execute("INSERT INTO object1_table VALUES(1, object1('str1', object2('obj2str1', 123)))");
    } catch (SQLException e) {
    }

 Related Examples