Oracle PL/SQL Programming: A Developer's Workbook

Intermediate

18-21.	What string is displayed on the screen when this code is executed? /* Filename on web page: sefx.sql */ DECLARE hollywood VARCHAR2(100) := 'Sound effects BAM!ARGH!BAM!HAM!'; BEGIN DBMS_OUTPUT.PUT_LINE (RTRIM (hollywood, 'BAM!ARGH!')); END;
18-22.	What string is displayed on the screen when this code is executed? BEGIN DBMS_OUTPUT.PUT_LINE (RTRIM ('ABCDEF', 'ABCDE')); END;
18-23.	Write a function to display the character set location or number for a specified character.
18-24.	Write a function to determine whether two different strings “sound” the same.
18-25.	Write a function that gives a name to (and makes accessible via that name) the newline character. Do the same for the tab character.
18-26.	Write a PL/SQL block that replaces all occurrences (regardless of case) of “YY” with “RR” in the following string: IF TO_DATE (my_date_str, 'MM-DD-YY') > TO_DATE (your_date_str, 'mmddyy')
18-27.	Write a function that strips all numeric digits from the specified string and returns what is left.
18-28.	Consider the following call to SUBSTR: SUBSTR ('Sunny February in Chicago', -10, 3) -- ruler 1234567890123456789012345 -- ruler 5432109876543210987654321 Which of the following substrings does this function return? in y i i y
18-29.	Consider the following call to INSTR: INSTR ( 'Sandy February in East Chicago', 'a', -15, 2) -- ruler 123456789012345678901234567890 -- ruler 098765432109876543210987654321 ...