Oracle PL/SQL Programming: A Developer's Workbook

Intermediate

20-11.	Write a function that returns TRUE if a number is odd.
20-12.	Which function returns the error message associated with a particular Oracle error number? GET_ERROR_MESSAGE ORA_MSG ORA_ERROR SQLERRM SQLCODE
20-13.	Write an exception section to display the current error code and its associated error message.
20-14.	Provide the format mask that prints the date “21-MAY-94” in the following formats: Desired Date Required Format May 21, 1994   05/21/94   The 21st of May, 1994   Quarter 2   Week 21   Week 3 in Month 05   The 3rd week in May
20-15.	Suppose you need to add a new value to the “end” of your PL/SQL or index-by table. In other words, if the last row used is 10, you want to put your next value in row 11. Here is one way to do it: IF names_list.LAST IS NULL THEN names_list( 1) := next_name; ELSE names_list (names_list.LAST + 1) := next_name; END IF; Rewrite the code so that you can do the assignment in a single line.
20-16.	Write a function that returns TRUE if the specified string is a valid number, FALSE if it is not. In other words, “123” and “–1e15” are valid numbers, while “123abc” is not.
20-17.	What is the output of this program? DECLARE v_number NUMBER (10) := ABS (-99); BEGIN IF v_number > -1 THEN DBMS_OUTPUT.put_line ('It''s positive'); ELSE DBMS_OUTPUT.put_line ('It''s negative'); END IF; END;
20-18.	What condition must be added to this code so it displays only every third row? DECLARE CURSOR curs_get_numbers IS SELECT * FROM a_bunch_of_numbers; BEGIN FOR v_number_rec IN curs_get_numbers ...