![]() |
The Java Developers Almanac 1.4Order this book from Amazon. |
e297. Inserting an OBJECT Value into an Oracle TableThis 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) { }
e298. Inserting an OBJECT Value into an Oracle Table Using a Prepared Statement e299. Getting an OBJECT Value from an Oracle Table e300. Deleting an OBJECT Type from an Oracle Table © 2002 Addison-Wesley. |