oracle数据库函数（国外英文资料）.docVIP

oracle数据库函数（国外英文资料） The function in oracle database: The cartesian set: the record of two tables multiplied Check the tree for several layers The select count (distinct level) from emp start with empno = 7839 connect by prior empno = MGR Select level, lpad (, 2 * level-1) | | ename from emp start with empno = 7839 connect by prior empno = MGR Use the set operator The set operator can combine two rows or rows returned by multiple queries. 1, union all: returns all rows retrieved from each query, including duplicate rows Union: returns all rows retrieved from each query, not including duplicate