C which of the following procedure and function calls

This preview shows page 6 - 7 out of 7 pages.

C. Which of the following procedure and function calls are valid and which are not? Explain why the invalid ones will fail.
7 FROM countries; 6. List the ways you can invoke (i.e., call) a function.
7. Create a function which accepts a character string as input and returns the same character string but with the order of the letters reversed. For example, "Smith" would be returned as "htimS." Save your code. Hint: you will need to declare a local variable to store the reversed string, and build its contents by reading the input one character at a time (using SUBSTR) in a loop structure, starting from the last character. Each execution of the loop reads the preceding character and concatenates it to the reversed string. 8. Test your function using the following SQL statements: SELECT last_name, reverse_string(last_name) FROM employees; SELECT country_name, reverse_string(country_name) FROM countries; Copyright © 2019, Oracle and/or its affiliates. All rights reserved. Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture