View Oracle table names via OracleConnection - Java JDBC

Java examples for JDBC:Oracle

  1. HOME
  2. Java
  3. JDBC
  4. Oracle

Description

View Oracle table names via OracleConnection

Demo Code

package JDBC;//from   w  ww . ja v  a 2s .  c om

import java.util.*;
import java.sql.*;
import oracle.jdbc.*;

class TableNameView {
  OracleConnection oconn;
  OracleStatement ost;
  OracleResultSet ors;
  String scomm;
  String vusername, vpassword, url;
  Scanner sc = new Scanner(System.in);

  public TableNameView() {
    try {
      DriverManager.registerDriver(new OracleDriver());
    } catch (SQLException ex) {
      System.out.println(ex.toString());
    }
    System.out.print("Enter User Name: ");
    vusername = sc.next();
    System.out.print("Enter Password: ");
    vpassword = sc.next();
    url = "jdbc:oracle:thin:@Islam-PC:1521:ORCL"; // change the hostname as per ur PC (Islam-PC)
    try {
      oconn = (OracleConnection) DriverManager.getConnection(url, vusername, vpassword);
      System.out.println("Oracle Connection successfully");
      System.out.println("Now Please See all the Table Name to view its record : ");

      scomm = "select TNAME from TAB";
      // instantiating the oracle statement
      ost = (OracleStatement) oconn.createStatement();
      // instantiating the oracle resultset
      ors = (OracleResultSet) ost.executeQuery(scomm);
      while (ors.next()) // if we use if instead of while den only first table wii
      {
        System.out.println(ors.getString(1));

      }

      // else
      // {
      // System.out.println("Either Table does not exists or Records does not
      // exists...");
      // }
      ors.close();
      ost.close();
      oconn.close();
    } catch (SQLException ex) {
      System.out.println(ex.toString());
    }

  }
}

public class ViewTableName {
  public static void main(String[] args) {
    TableNameView ro = new TableNameView();
  }
}

Related Tutorials