小文子

Oracle Connect By用法oracle中的select语句可以用START WITH...CONNECT BY PRIOR子句实现递归查询，connect by 是结构化查询中用到的，其基本语法是：select ... from <TableName> where <Conditional-1>start with <Conditiona...

select to_char((trunc(sysdate) + trunc((end_time - trunc(sysdate)) * 24 * 60 / 40) * 40 / 60 / 24), 'hh24:mi') || '-' || to_char((trunc(sysdate) + trunc((end_tim...