OracleCreateTable.java - Oracle JDBC Create Table

Q

How to create a new table in Oracle using the ojdbc Oracle Driver? I want to see a Java program example.

✍: FYIcenter.com

A

Here is a Java example that shows you how to create a new table in Oracle using the ojdbc Oracle Driver:

// Copyright (c) FYIcenter.com
import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;

// Example of ojdbc Oracle Driver to create a new table
public class OracleCreateTable {
   public static void main(String [] args) throws Exception {

      // Oracle JDBC connection URL with required elements
      String url = "jdbc:oracle:thin:SYS AS SYSDBA/fyicenter@//localhost/XE";
      Connection con = DriverManager.getConnection(url);
      System.out.println("JDBC connection URL: "+url); 
      System.out.println("   Connected to: "+con.getCatalog()); 

      // Create a new table "Profile"
      String sql = "CREATE TABLE Profile (ID INTEGER, Name VARCHAR(80))";
      Statement st = con.createStatement();
      st = con.createStatement();
      st.execute(sql);
      System.out.println("   Table Profile columns:");
      sql = "SELECT * FROM Profile";
      ResultSet rs = st.executeQuery(sql);
      ResultSetMetaData md = rs.getMetaData();
      System.out.println("      "+md.getColumnName(1)
         +": "+md.getColumnTypeName(1));
      System.out.println("      "+md.getColumnName(2)
         +": "+md.getColumnTypeName(2));
      
      // Drop the new table
      st.execute("DROP TABLE Profile");
      con.close();
   }
}

You can compile and run the above example in a command window as shown below:

C:\fyicenter>\local\jdk-1.8.0\bin\javac 
   OracleCreateTable.java

C:\fyicenter>\local\jdk-1.8.0\bin\java
  -cp .;\fyicenter\Oracle-11.2.0.4\ojdbc6.jar 
  OracleCreateTable

JDBC connection URL: jdbc:oracle:thin:SYS AS SYSDBA/fyicenter@//localhost/XE
   Connected to: null
   Table Profile columns:
      ID: NUMBER
      NAME: VARCHAR2

Note that getColumnName(index) and getColumnTypeName(index) methods take input index value starting from 1, not 0.

 

Examples for ojdbc.jar - JDBC Driver for Oracle

⇒⇒FAQ for ojdbc.jar - JDBC Driver for Oracle

2018-03-28, 503👍, 0💬