Skip to content

Instantly share code, notes, and snippets.

@JubbaSmail

JubbaSmail/pl_sql_explicit_cursor.sql

Created December 22, 2014 22:59
Show Gist options
  • Save JubbaSmail/772ba71a3b9f4ebccef1 to your computer and use it in GitHub Desktop.
Save JubbaSmail/772ba71a3b9f4ebccef1 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
pl_sql_explicit_cursor.sql
DECLARE
CURSOR x IS
SELECT cust_first_name,cust_last_name FROM customers;
BEGIN
FOR y in x loop
dbms_output.put_line
('The emp name is '|| y.cust_first_name ||
' ' || y.cust_last_name);
END LOOP;
END;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment