2. Create PL/SQL Function To Call Java Class
3. Testing your Java Code (test as any Oracle PL/SQL function)


Oracle table row count using Java (JDBC with default or currently opened connection). The "Connection" code can be revised to connect to the database from an external application
1. Create Java class named "OraObjRowcount"

2. Create PL/SQL Function To Call Java Class (returns a NUMBER)
3. Testing your Java Code (pass TABLE_NAME as the parameter)


The above code refined to show useful output
1. Create Java class named "OraTableRowcount"

2. Create PL/SQL Function To Call Java Class (returns a string - VARCHAR2)

3. Testing your Java Code (pass TABLE_NAME as the parameter)




For corrections or feedback, other useful links please contact webmaster

  1408