How to Create Oracle Table in Java?

Below Java code shows, how to create Oracle Table using JDBC Driver –

 * Created on 05-2011 Copyright(c) All Rights Reserved.
package com.kodehelp.javasql;

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

 * Created by
 * Date: 5/2/11
public class CreateOracleTable {
    public static void main(String args[]) throws SQLException, ClassNotFoundException {
        final String driver = "oracle.jdbc.driver.OracleDriver";
        final String url = "jdbc:oracle:thin:@HOST:PORT:SID";
        final String USERNAME = "USERNAME";
        final String PASSWORD = "PASSWORD";
        Class.forName(driver); // load Oracle driver
        Connection conn = DriverManager.getConnection(url, USERNAME, PASSWORD);
        String sql = "CREATE TABLE PRODUCTS (id NUMBER(11), NAME VARCHAR2(64))";
        Statement statement = conn.createStatement();

Please Post Your Comments & Reviews

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.