单行函数的一些知识点

文档地址：http://docs.oracle.com/cd/B19306_01/server.102/b14200/functions001.htm#sthref914

 

Single-Row Functions

   Single-rowfunctions return a single result row for every row of a queriedtable or view.

 

   These functions canappear in select lists, WHERE clauses,START WITH and CONNECTBY clauses, and HAVINGclauses.--单行函数能够出现在select lists, WHERE clauses,START WITH and CONNECTBY clauses, and HAVINGclauses中，当然还包括ORDER BY字句。