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, 2192🔥, 0💬
Popular Posts:
JDK 11 jdk.rmic.jmod is the JMOD file for JDK 11 RMI (Remote Method Invocation) Compiler Tool tool, ...
JDK 11 jdk.crypto.mscapi.jmod is the JMOD file for JDK 11 Crypto MSCAPI module. JDK 11 Crypto MSCAPI...
What Is log4j-1.2.15.jar? I got the JAR file from apache-log4j-1.2.15.zip. log4j-1.2.15.jar is the v...
XOM™ is a new XML object model. It is an open source (LGPL), tree-based API for processing XML with ...
How to run "jarsigner" command from JDK tools.jar file? "jarsigner" command allows you to digitally ...