Categories:
Audio (13)
Biotech (29)
Bytecode (36)
Database (77)
Framework (7)
Game (7)
General (507)
Graphics (53)
I/O (35)
IDE (2)
JAR Tools (101)
JavaBeans (21)
JDBC (121)
JDK (426)
JSP (20)
Logging (108)
Mail (58)
Messaging (8)
Network (84)
PDF (97)
Report (7)
Scripting (84)
Security (32)
Server (121)
Servlet (26)
SOAP (24)
Testing (54)
Web (15)
XML (309)
Collections:
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, 1982🔥, 0💬
Popular Posts:
commons-lang-2.6.jar is the JAR file for Apache Commons Lang 2.6, which provides a host of helper ut...
JDK 11 jdk.aot.jmod is the JMOD file for JDK 11 Ahead-of-Time (AOT) Compiler module. JDK 11 AOT Comp...
Jakarta Regexp is a 100% Pure Java Regular Expression package that was graciously donated to the Apa...
commons-fileupload-1.3.3 -sources.jaris the source JAR file for Apache Commons FileUpload 1.3., whic...
JDK 11 jdk.internal.JVM Stat.jmod is the JMOD file for JDK 11 Internal Jvmstat module. JDK 11 Intern...