这个压缩包里的都是超级经典的java例子
源代码在线查看: dropobjectoracle.htm
Deleting an OBJECT Type from an Oracle Table (Java Developers Almanac Example)
The Java Developers Almanac 1.4
Order this book from Amazon.
google_ad_client = "pub-6001183370374757";
google_ad_width = 120;
google_ad_height = 600;
google_ad_format = "120x600_as";
google_ad_channel = "4777242811";
google_ad_type = "text_image";
google_color_border = "FFFFFF";
google_color_bg = "FFFFFF";
google_color_link = "6666CC";
google_color_url = "6666CC";
google_color_text = "000000";
//-->
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.