1.遞歸查詢

SELECT * FROM tree START WITH id = 2 CONNECT BY PRIOR pid = id -- 遞歸查詢父節(jié)點
union
SELECT * FROM tree START WITH id = 2 CONNECT BY pid = PRIOR id; -- 遞歸查詢子節(jié)點

2.時間戳

select (SYSDATE - TO_DATE('1970-1-1 8', 'YYYY-MM-DD HH24')) * 86400000 + TO_NUMBER(TO_CHAR(SYSTIMESTAMP(3),'FF') ) FROM DUAL;