Advertisement
Guest User

Untitled

a guest
Feb 20th, 2019
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.34 KB | None | 0 0
  1. select /*+ parallel(a) */ min(action_objid) from TMP_OA a;
  2. select /*+ parallel(a) */ max(action_objid) from TMP_OA a;
  3.  
  4. partition 1=min(action_objid) + 1* (max(action_objid) /10)
  5. partition 2=min(action_objid) + 2* (max(action_objid) /10) -partition 1
  6. ....
  7. partition 10=min(action_objid) + 10* (max(action_objid) /10) - all nine partitions
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement