To work with JDBC, you will need to know the basics of RDBMS and SQL. You may also want to setup an environment where you can practice things. These notes will help you in these.

1. http://datastudy.club/en/book/rdbms-and-sql-notes

First we will create an array (nested table array or varray), use it in a stored procedure as OUT parameter and then populate and retrieve data through a JDBC program.

Creating array

We can create a nested table array as:

CREATE TYPE array_table AS TABLE OF VARCHAR2 (50);

Or

We can create a VARRAY as:

CREATE TYPE array_table AS VARRAY(5) OF VARCHAR2(50);

First we will create an array (nested table array or varray), use it in a stored procedure as IN and/or OUT parameters and then populate and retrieve data through a JDBC program.

Creating array

We can create a nested table array as:

CREATE TYPE array_table AS TABLE OF VARCHAR2 (50);

Or

import java.sql.Array;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.Statement;

public class JDBCArrayClient {

  public static void passArray() {

    try {

      Class.forName("oracle.jdbc.OracleDriver");

      // Need to modify conn string, username and password as per your oracle installation.

      Connection con = DriverManager.getConnection(

This page will try to list all notes within JavaJee.com that need to be referred, in addition to the Beginning Java Book for preparing for the exam OCA Java SE Programmer I Certification.

• Object Oriented

  • http://javajee.com/beginning-object-oriented-programming-in-java

• Character, Strings and Arrays

  • http://javajee.com/characters-strings-and-arrays-in-java