SQL

1、 Oracle日期函数：select sysdate from dual;

2、TO_CHAR(sysdate,'hh24:mi:ss')

3、ORACLE查询树型关系：start with connect by prior