| A | B |
|---|
| CHAR | data type used for text and character data of fixed length, including numbers, dashes, and special characters |
| Fm | used to remove padded blanks or to suppress leading zeros. |
| NUMBER | data type used to store variable length numeric data |
| Conversion Function | Functions that convert a value from one datatype to another |
| VARCHAR2 | datatype used for character data of variable length, including numbers, special characters, and dashes |
| DATE | datatype used for date and time values |
| TO_CHAR | converts dates or numbers to character strings with optional formatting |
| RR date format | century value depends on the specified year and the last two digits of the current year |
| TO_NUMBER | converts a character string containing digits to a number with optional formatting |
| DD date format | numeric day of the month |
| TO_DATE | converts a character string representing a date to a date value with optional formatting |
