Deleting an OBJECT Type from an Oracle Table - Java JDBC

Java examples for JDBC:Oracle

  1. HOME
  2. Java
  3. JDBC
  4. Oracle

Description

Deleting an OBJECT Type from an Oracle Table

Demo Code

import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Statement;

public class Main {
  public static void main(String[] args) throws Exception {
    try {//from ww w  .  j  a v a2s. co m
      Connection connection = null;
      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) {
    }
  }
}

Related Tutorials