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