Expert
26-22. | Describe what happens when the call spec specified for the following class is created and executed: public class helloWorld { public static void doit () { System.out.println("Hello World!!!"); } } -- Call spec used for the class CREATE OR REPLACE PROCEDURE my_hello AS LANGUAGE JAVA NAME 'helloWorld.doIt()'; |
26-23. | Describe what happens when the call spec specified for the following class is created and executed: public class helloWorld { public void doit () { System.out.println("Hello World!!!"); } } -- Call spec used for the class CREATE OR REPLACE PROCEDURE my_hello AS LANGUAGE JAVA NAME 'helloWorld.doit()'; |
26-24. | Write a query to display information about the Java objects in a user schema. |
26-25. | Write a procedure to print the source code for a Java-stored procedure (assuming, of course, that the source has been loaded). |
26-26. | Write a call spec for the following Java class: public class NumberTest{ public static void smallestFirst (int[] a, int[] b) { int tmp = a[0]; if (a[0] > b[0]) { a[0] = b[0]; b[0] = tmp; } } } |
26-27. | Complete the following call spec: CREATE OR REPLACE FUNCTION wages (e Employee) RETURN NUMBER
AS LANGUAGE JAVA
NAME 'Paymaster.wages( |
26-28. | You have been asked to design a PL/SQL interface for a subset of the methods in a Java file-manipulation class. Specifically, you are to write two functions and one procedure: a function that deletes a given file and returns a Boolean flag indicating whether the delete succeeded; a function that ... |
Get Oracle PL/SQL Programming: A Developer's Workbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.