Categories:
Audio (13)
Biotech (29)
Bytecode (35)
Database (77)
Framework (7)
Game (7)
General (512)
Graphics (53)
I/O (32)
IDE (2)
JAR Tools (86)
JavaBeans (16)
JDBC (89)
JDK (337)
JSP (20)
Logging (103)
Mail (54)
Messaging (8)
Network (71)
PDF (94)
Report (7)
Scripting (83)
Security (32)
Server (119)
Servlet (17)
SOAP (24)
Testing (50)
Web (19)
XML (301)
Other Resources:
OracleCreateTable.java - Oracle JDBC Create Table
How to create a new table in Oracle using the ojdbc Oracle Driver? I want to see a Java program example.
✍: FYIcenter.com
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.
Â
⇒ OracleInsertRow.java - Oracle JDBC Insert Row
⇠OracleJdbcConnection.java - Oracle JDBC Connection
2018-03-28, 1816👍, 0💬
Popular Posts:
commons-lang-1.0.1.jar is the JAR file for Apache Commons Lang 1.0.1, which provides a host of helpe...
JDK 11 jdk.internal.le.jmod is the JMOD file for JDK 11 Internal Line Editing module. JDK 11 Interna...
What Is HttpComponents httpclient-4.2.2.jar? HttpComponents httpclient-4.2.2.jar is the JAR file for...
JDK 11 jdk.localedata.jmod is the JMOD file for JDK 11 Localedata module. JDK 11 Locale Data module ...
What Is poi-ooxml-3.5.jar? poi-ooxml-3.5.jar is one of the JAR files for Apache POI 3.5, which provi...