Advertisement
psi_mmobile

Untitled

Apr 18th, 2024
492
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 3.50 KB | None | 0 0
  1. SELECT vd.vehicle_id FROM person_data pd, vehicle_data vd
  2. WHERE pd.person_id IN (105870,105768,105769,105863,105763,105777,109876,105836,105821,105957,103858,115350,105855,111392,120479,124102,124146,105773,105833,103872,105854,105818,105849,105869,114682,115552,103357,105827,105861,110519,121990,105868,105939,125850,105867,105780,105840,105872,112318,121992,105792,115342,126295,105779,116409,124765,125852,105772,105857,107362,121984,103365,114609,105839,119720,105825,105765,105814,105852,105829,106251,105859,105834,125849,105770,105933,105819,105874,107737,105766,105843,110518,109988,134690,366894,655303,655305,655304)
  3. AND pd.event_date >= SYSDATE - 128
  4. AND pd.vehicle_data_id = vd.vehicle_data_id;
  5.  
  6. SELECT * FROM gu_vehicle;
  7.  
  8. INSERT INTO gu_vehicle (vehicle_id,gui_user_id) VALUES (119031,213019);
  9. INSERT INTO gu_vehicle (vehicle_id,gui_user_id) VALUES (187578,213019);
  10. INSERT INTO gu_vehicle (vehicle_id,gui_user_id) VALUES (123044,213019);
  11. INSERT INTO gu_vehicle (vehicle_id,gui_user_id) VALUES (184077,213019);
  12. INSERT INTO gu_vehicle (vehicle_id,gui_user_id) VALUES (196365,213019);
  13. INSERT INTO gu_vehicle (vehicle_id,gui_user_id) VALUES (123042,213019);
  14. INSERT INTO gu_vehicle (vehicle_id,gui_user_id) VALUES (187615,213019);
  15. INSERT INTO gu_vehicle (vehicle_id,gui_user_id) VALUES (169516,213019);
  16. INSERT INTO gu_vehicle (vehicle_id,gui_user_id) VALUES (119495,213019);
  17. INSERT INTO gu_vehicle (vehicle_id,gui_user_id) VALUES (195241,213019);
  18. INSERT INTO gu_vehicle (vehicle_id,gui_user_id) VALUES (169363,213019);
  19. INSERT INTO gu_vehicle (vehicle_id,gui_user_id) VALUES (119885,213019);
  20. INSERT INTO gu_vehicle (vehicle_id,gui_user_id) VALUES (122643,213019);
  21. INSERT INTO gu_vehicle (vehicle_id,gui_user_id) VALUES (122741,213019);
  22. INSERT INTO gu_vehicle (vehicle_id,gui_user_id) VALUES (119554,213019);
  23. INSERT INTO gu_vehicle (vehicle_id,gui_user_id) VALUES (188726,213019);
  24. INSERT INTO gu_vehicle (vehicle_id,gui_user_id) VALUES (123020,213019);
  25. INSERT INTO gu_vehicle (vehicle_id,gui_user_id) VALUES (190856,213019);
  26. INSERT INTO gu_vehicle (vehicle_id,gui_user_id) VALUES (123041,213019);
  27. INSERT INTO gu_vehicle (vehicle_id,gui_user_id) VALUES (169522,213019);
  28. INSERT INTO gu_vehicle (vehicle_id,gui_user_id) VALUES (120898,213019);
  29. INSERT INTO gu_vehicle (vehicle_id,gui_user_id) VALUES (184075,213019);
  30. INSERT INTO gu_vehicle (vehicle_id,gui_user_id) VALUES (123367,213019);
  31. INSERT INTO gu_vehicle (vehicle_id,gui_user_id) VALUES (194336,213019);
  32. INSERT INTO gu_vehicle (vehicle_id,gui_user_id) VALUES (123038,213019);
  33. INSERT INTO gu_vehicle (vehicle_id,gui_user_id) VALUES (169527,213019);
  34. INSERT INTO gu_vehicle (vehicle_id,gui_user_id) VALUES (169549,213019);
  35. INSERT INTO gu_vehicle (vehicle_id,gui_user_id) VALUES (122766,213019);
  36. INSERT INTO gu_vehicle (vehicle_id,gui_user_id) VALUES (169524,213019);
  37. INSERT INTO gu_vehicle (vehicle_id,gui_user_id) VALUES (187585,213019);
  38. INSERT INTO gu_vehicle (vehicle_id,gui_user_id) VALUES (123220,213019);
  39. INSERT INTO gu_vehicle (vehicle_id,gui_user_id) VALUES (123146,213019);
  40. INSERT INTO gu_vehicle (vehicle_id,gui_user_id) VALUES (123363,213019);
  41. INSERT INTO gu_vehicle (vehicle_id,gui_user_id) VALUES (169515,213019);
  42. INSERT INTO gu_vehicle (vehicle_id,gui_user_id) VALUES (120917,213019);
  43. INSERT INTO gu_vehicle (vehicle_id,gui_user_id) VALUES (194346,213019);
  44. INSERT INTO gu_vehicle (vehicle_id,gui_user_id) VALUES (183914,213019);
  45. INSERT INTO gu_vehicle (vehicle_id,gui_user_id) VALUES (121272,213019);
  46. COMMIT;
  47.  
  48. SELECT * FROM gu_vehicle
  49. WHERE gui_user_id = 213019;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement