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, 2128🔥, 0💬
Popular Posts:
JLayer is a library that decodes/plays/converts MPEG 1/2/2.5 Layer 1/2/3 (i.e. MP3) in real time for...
JDK 11 jdk.rmic.jmod is the JMOD file for JDK 11 RMI (Remote Method Invocation) Compiler Tool tool, ...
Where to find answers to frequently asked questions on Download and Installing of Older Versions? He...
How to download and install ojdbc11.jar for Oracle 21c? ojdbc11.jar for Oracle 21c is a Java JDBC Dr...
The Web Services Description Language for Java Toolkit (WSDL4J), Release 1.6.2, allows the creation,...