Previous | Table of Contents | Next

Page 66

  1. What can you do to ignore the time portion of a DATE variable?
  2. When comparing a VARCHAR2 and a CHAR variable, how can you eliminate any trailing spaces?

Exercises

  1. Try writing an anonymous block that declares a variable and displays its value. Then add a nested block that declares a variable of the same name and displays its value. What happens and why?
  2. Write a function that computes a person's age in years. Hint: To get started on this, look at Listing 3.3.

Previous | Table of Contents | Next

Используются технологии uCoz