Posted in: JDBC
package com.JavaStuff.jdbc;


import java.sql.*;
import java.util.*;
/**
 * @author JavaStuff
 */


public class ResultSetMetaDataExample{


public static void main(String s[]) throws Exception {
Driver d=(Driver) Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();


Connection con = d.connect(                     "jdbc:oracle:thin:@localhost:1521:java","scott","tiger");


Statement st = con.createStatement();


ResultSet rs=st.executeQuery("select * from "+s[0]);
//Table name is taken as an command line arg


ResultSetMetaData rsmd=rs.getMetaData();


System.out.println("Table Name : "+s[0]);

int colcount=rsmd.getColumnCount();


for (int i=1;i<=colcount;i++) {
System.out.print(rsmd.getColumnName(i)+"\t");
System.out.println(rsmd.getColumnTypeName(i));
}//for


con.close();
}//main
}//class

Note :To execute the following example you can replace username and password with your actual user name and password.