e300. deleting an object type from an oracle table.txt

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

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
    }