Advertisement
rafibatam

PL/pgSQL Variables

Jul 31st, 2019
102
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. DO $$
  2. DECLARE
  3.     first_name  VARCHAR(30) := 'Muhammad Rafi';
  4.     last_name   VARCHAR(30) := 'Bahrur Rizki';
  5.     car         VARCHAR(30) := 'Bugatti Chiron';
  6.     years       INTEGER     := 2025;
  7. BEGIN
  8.     RAISE NOTICE '% % wanna buy a % in % Insya Allah', first_name, last_name, car, years;
  9. END $$;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement