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?
| ||||||||||||||||
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:
| ||||||||||||||||
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 ... |
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.