new第4章 单行函数.pptVIP

* Implicit Data Type Conversion The assignment succeeds if the Oracle server can convert the data type of the value used in the assignment to that of the assignment target. Instructor Note There are several new data types available in the Oracle9i release pertaining to time. These include: TIMESTAMP, TIMESTAMP WITH TIME ZONE, TIMESTAMP WITH LOCAL TIME ZONE, INTERVAL YEAR, INTERVAL DAY. These are discussed later in the course. You can also refer students to the Oracle9i SQL Reference, “Basic Elements of Oracle SQL.” * Displaying a Date in a Specific Format Previously, all Oracle date