Oracle
文章平均质量分 77
haha00007
这个作者很懒,什么都没留下…
展开
-
ORACLE 中的SYS_CONNECT_BY_PATH 函数
语法 用法 SYS_CONNECT_BY_PATH is valid only in hierarchical queries. It returns the path of a column value from root to node, with column values separated by char for each row returned by CONNECTBY原创 2013-06-04 14:23:28 · 485 阅读 · 0 评论 -
ORACLE中的ROW_NUMBER函数
The ROW_NUMBER function assigns a unique number (sequentially, starting from 1, as defined by ORDER BY) to each row within the partition. It has the following syntax: ROW_NUMBER ( ) OVER ( [query_par原创 2013-06-04 14:37:48 · 670 阅读 · 0 评论 -
ORACLE中的ROUND函数
ROUND (number) 语法 用法 ROUND returns n rounded tointeger places to the right of the decimal point. If you omitinteger, then n is rounded to 0 places. The argumentinteger can be negative to原创 2013-06-05 10:54:40 · 761 阅读 · 0 评论