java类库详细讲解

				
				
				
				Deleting an OBJECT Type from an Oracle Table
				(Java Developers Almanac Example)
				
				
				
				
				
				
								    BODY CODE  {font-family: Courier, Monospace;				           font-size: 11pt}				    TABLE, BODY				          {font-family: Verdana, Arial, Helvetica, sans-serif;				           font-size: 10pt}				    PRE   {font-family: Courier, Monospace;				           font-size: 10pt}				    H3    {font-family: Verdana, Arial, Helvetica, sans-serif;				           font-size: 11pt}				    A.eglink {text-decoration: none}				    A:hover.eglink {text-decoration: underline}				    -->
				
				
				
				
				
				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.