摘要:
1.时间的处理 获取年: to_char(hiredate,'MM'); 这里hiredate是date类型,格式1981/4/2 同理:to_char(hiredate,'yyyy') year,to_char(hiredate,'MM') month 2.表中存在树形结构 start with 阅读全文
摘要:
connect by 是结构化查询中用到的,其基本语法是:select … from tablename start with 条件1connect by 条件2where 条件3;例:select * from tablestart with org_id = ‘HBHqfWGWPy’connec 阅读全文