package org.kodejava.example.sql;

import java.sql.*;

public class GettingTableListExample {
    public static void main(String[] args) throws Exception {
        Connection connection = null;
        try {
            Class.forName("oracle.jdbc.driver.OracleDriver");
            String url = "jdbc:oracle:thin:@localhost:1521:xe";
            String username = "kodejava";
            String password = "kodejava123";
            connection = DriverManager.getConnection(url, username, password);

            // Gets the metadata of the database
            DatabaseMetaData metaData = connection.getMetaData();
            String[] types = {"TABLE"};

            ResultSet rs = metaData.getTables(null, null, "%", types);
            while (rs.next()) {
                String tableCatalog = rs.getString(1);
                String tableSchema = rs.getString(2);
                String tableName = rs.getString(3);

                System.out.printf("%s - %s - %s%n", tableCatalog, tableSchema,
                        tableName);
            }
        } finally {
            try {
                if (connection != null && !connection.isClosed()) {
                    connection.close();
                }
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
}

Here is the result

null - KODEJAVA - BOOKS

• About
• Latest Posts

Wayan

Programmer, runner, recreational diver, live in the island of Bali, Indonesia. Mostly programming in Java, creating web based application with Spring Framework, Hibernate / JPA.

Latest posts by Wayan (see all)

• How to format LocalDate object using Jackson? - February 16, 2017
• How to pretty print JSON string using Jackson? - February 15, 2017
• How to convert java.time.LocalDate to java.util.Date? - February 14, 2017