Answers to Chapter 7
 | Reviewing It |
| 1: | What is the purpose of SQL functions? |
| A1: | SQL functions perform a variety of tasks such as date compares, date formatting, a host of character functions, as well as several numerical functions |
| 2: | What is the DUAL table useful for? |
| A2: | The DUAL table contains one column and one row and is useful when wanting to run a function once |
| 3: | Explain SQL concatenation. |
| A3: | Concatenation is when two or more columns are merged together, many times merged with some text items, to form a single column of outout |
| 4: | The DECODE statement is what? |
| A4: | The DECODE function is the IF-THEN-ELSE logic to SQL |
| 5: | When might you use the HAVING ... |
Get Oracle9i™ Development by Example 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.
