psi_mmobile

Untitled

Oct 20th, 2021
769
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT
  2.     kc.vehicle_id,
  3.     LISTAGG(
  4.         kc.key_string,
  5.         ';'
  6.     ) WITHIN GROUP(
  7.     ORDER BY
  8.         kc.key_code_usage_id
  9.     ) AS object_key_strings
  10. FROM
  11.     key_code kc
  12. WHERE kc.key_string NOT LIKE '%http%'
  13. AND kc.key_string IS NOT NULL
  14. AND kc.vehicle_id IS NOT NULL
  15. GROUP BY
  16.     kc.vehicle_id;
RAW Paste Data