📄 e300. deleting an object type from an oracle table.txt
字号:
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
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -