The Java Developers Almanac 1.4


Order this book from Amazon.

   
Home > List of Packages > java.sql  [73 examples] > Oracle OBJECTs  [5 examples]

e300. Deleting an OBJECT Type from an Oracle Table

This example deletes the OBJECTs and tables created in e296 Creating an OBJECT Type in an Oracle Database.
    try {
        // Create a statement
        Statement stmt = connection.createStatement();
    
        // Drop table object1_table and types object1 and object2
        stmt.execute("DROP TABLE object1_table");
        stmt.execute("DROP TYPE object1 FORCE");
        stmt.execute("DROP TYPE object2 FORCE");
    } catch (SQLException e) {
        // A drop statement will throw an exception if the table or type does not exist
    }

 Related Examples
e296. Creating an OBJECT Type in an Oracle Database
e297. Inserting an OBJECT Value into an Oracle Table
e298. Inserting an OBJECT Value into an Oracle Table Using a Prepared Statement
e299. Getting an OBJECT Value from an Oracle Table

See also: Batching    Connections    Database Meta Data    Deleting Data    Drivers    Importing and Exporting    Inserting and Updating Data    Oracle VARRAYs    Procedures and Functions    Retrieving Data    Scrollable Result Sets    Tables    Updatable Result Sets   


© 2002 Addison-Wesley.