fahadkalil

plpgsql_cursor_for_2025

Oct 10th, 2025 (edited)
474
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.18 KB | Source Code | 0 0
  1. DO $$
  2. DECLARE
  3.   item RECORD;
  4. BEGIN
  5.   FOR item IN (SELECT first_name, last_name FROM staff)
  6.   LOOP
  7.     RAISE notice '% | %', item.first_name, item.last_name;  
  8.   END LOOP;
  9. END $$;
Advertisement
Add Comment
Please, Sign In to add comment