// Import the following packages to use JDBC.
import  java.sql.*;
import  java.io.*;
import  oracle.sql.*;
import  oracle.jdbc.*;
import  oracle.jdbc.pool.OracleDataSource;

class   DynamicSQL {
  public static void  main( String args[ ] ) throws SQLException {
    String user     = "C##user.id";
    String password = "password";
    String database = "65.52.222.73:1521/cdb1";

    // Open an OracleDataSource and get a connection.
    OracleDataSource ods = new OracleDataSource( );
    ods.setURL     ( "jdbc:oracle:thin:@" + database );
    ods.setUser    ( user );
    ods.setPassword( password );
    Connection conn = ods.getConnection( );

    try {
      // The parameter, sql, is too long as an argument.
      // Read the parameter, sql, written to the file p1.txt.
      FileInputStream    stream     = new FileInputStream  ( "p1.txt" );
      InputStreamReader  iStrReader = new InputStreamReader( stream );
      BufferedReader     reader     = new BufferedReader   ( iStrReader );
      String  sql = reader.readLine( );
      if ( sql == null )  sql = "";
      else  sql = sql.trim( );
 
      try {
        Statement  stmt = conn.createStatement( );
        System.out.print( "" + sql + "" );
        if ( stmt.execute( sql ) ) {
          ResultSet          results = stmt.getResultSet( );
          ResultSetMetaData  meta    = results.getMetaData( );
          int  cols = meta.getColumnCount( );
          while ( results.next( ) )
            for ( int i = 1;  i <= cols;  i++ ) {
              Object  ob = results.getObject( i );
              System.out.print( meta.getColumnLabel( i ) + " ➜ " + ob.toString( ) );
            }
          results.close( );
        } 
        stmt.close( );      
      }
      catch ( SQLException ex ) { System.out.println( ex ); } 
    }
    catch ( IOException ex ) { System.out.println( ex ); } 
    conn.close( );
  }
}