Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DO $$
- declare
- /*
- * -->counter is variable and integer is type data
- * -->first_name is variable and varchar is type data
- * -->last_name is variable and varchar is type data
- * -->payment is variable and numeric is type data
- */
- counter INTEGER := 1;
- first_name VARCHAR(50) := 'Rahmad';
- last_name VARCHAR(50) := 'Nasution';
- payment NUMERIC(11,2) := 20.5;
- BEGIN
- RAISE NOTICE '% % % has been paid % USD', counter, first_name, last_name, payment;
- END $$;
Advertisement
Add Comment
Please, Sign In to add comment