Advertisement
VoronVU

Untitled

Aug 28th, 2014
524
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT
  2.   /*+CARDINALITY(t14)*/
  3.   column_value
  4.  ,COUNT(START_STATUS_DATE) AS cnt
  5. FROM
  6.   REP_ASMRGA_ALINE tl
  7.  ,TABLE(pipe_date(TRUNC(SYSDATE)-14,14))
  8. WHERE
  9.   column_value = tl.START_STATUS_DATE(+)
  10. GROUP BY
  11.   column_value
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement