Personal oracle lite (POL) - Explain how to write Java Stored Procedures posted
by Babu Kunwar
Explain how to write Java Stored Procedures
A Java stored procedure is a procedure that is written in Java instead of 3GL
languages like PL/SQL and stored in the Oracle database.
The following is a simple example of the usage of the Java stored procedure:
public class ExampleClass {
public static String changeToUpper(String str) {
return str.toUpperCase ();
}
}
More links
What are Cursors?
Define cursor attributes: %FOUND, %NOTFOUND, %ROWCOUNT, and %ISOPEN
What are cursor variables? Explain with an example
Significance of SELECT FOR UPDATE clause. Write syntax
Significance of WHERE CURRENT OF clause. Write syntax..........
|
