Advertisement
Guest User

Untitled

a guest
Feb 26th, 2019
2,002
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.15 KB | None | 0 0
  1. tom@gmail.com webapp4 webapps
  2. tom@gmail.com webapp6 webapps
  3. tom@gmail.com mswin3 windows
  4. tom@gmail.com mswin2 windows
  5. sakur@gmail.com mswin2 windows
  6. sakur@gmail.com webapp6 webapps
  7.  
  8. SELECT *
  9. FROM ( SELECT 'SYNC rss_user WITH rss_user_name = "'
  10. || RSS_USER_NAME
  11. || '" , rss_name = "'
  12. || RSS_NAME
  13. || '" , rss_type = "'
  14. || RSS_TYPE
  15. || '";'
  16. FROM rss_user
  17. ORDER BY DBMS_RANDOM.VALUE)
  18. WHERE ROWNUM = 1
  19.  
  20. SYNC rss_user WITH rss_user_name = "tom@gmail.com" , rss_name = "webapp4" , rss_type = "webapps";
  21.  
  22. SELECT *
  23. FROM (SELECT 'SYNC rss_user WITH rss_user_name = "'
  24. || RSS_USER_NAME
  25. || '" , rss_name = "'
  26. || RSS_NAME
  27. || '" , rss_type = "'
  28. || RSS_TYPE
  29. || '";',
  30. seqnum = row_number() over (partition by rss_name, rss_type order by dbms_random.value)
  31. FROM rss_user
  32. ) t
  33. WHERE seqnum = 1
  34.  
  35. select rss_name, rss_type, max(rand) from
  36. (select rss_name, rss_type, <random number> as rand from rss_user) a
  37. group by rss_name, rss_type
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement