Oracle function report.
Your second assignment is to prepare a short report about several Oracle functions. Your report should include a
description of each function, explanations how to use it, and examples of select statements illustrating
usage of the function. Here is the list of the functions assigned to each of you:
- Cai, Dejia
- ceil
- lower
- current_date
- extract
- soundex
- Jones, Marques D.
- to_number
- round
- last_day
- instr
- initcap
- Surmacz, Sean D.
- to_date
- add_months
- trunk
- translate
- sign
- Ulincy, Jonathan B.
- to_char
- sysdate
- months_between
- floor
- replace
- Watson, Joshua L.
- to_timestamp
- systimestamp
- length
- upper
- substr
You can find some information in the textbook for the class. Also all the information is in the
Oracle Technology Network section Documentation.
Your report is due on Tuesday September 10, 2002 by the class time.