Here you will find the code base to search for the list of columns in a table in Oracle DB.
Note* : You need to provide the oracle DB related details in code(e.g. userId & password etc)
/*
* Here we will learn to access columns in tables using DB Metadata
*/
package jbt;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class AccessTableCoulmn {
public static void main(String[] args) throws SQLException,
ClassNotFoundException {
Class.forName("oracle.jdbc.OracleDriver");
String serverName = "172.20.6.34";
String portNumber = "1541";
String sid = "NCSS10DV";
String url = "jdbc:oracle:thin:@" + serverName + ":" + portNumber + ":"
+ sid;
String username = "ncsdba";
String password = "mig123";
Connection conn = DriverManager.getConnection(url, username, password);
Statement stmt = conn.createStatement();
ResultSet rs = stmt
.executeQuery("SELECT column_name, data_type, data_length"
+ " FROM user_tab_columns"
+ " WHERE table_name = 'JBT_TABLE'");
while (rs.next()) {
System.out.print(rs.getString(1));
System.out.print(" ");
System.out.print(rs.getString(2));
System.out.print(" ");
System.out.println(rs.getString(3));
}
}
}