Skip to content

Instantly share code, notes, and snippets.

@adityadaniel
Created June 3, 2017 08:00
Show Gist options
  • Save adityadaniel/6b4ab300d886c26d4b15dd7a86d4e889 to your computer and use it in GitHub Desktop.
Save adityadaniel/6b4ab300d886c26d4b15dd7a86d4e889 to your computer and use it in GitHub Desktop.
declare
i number(1);
Nama varchar2(100);
begin
<< outer_loop >>
select first_name into nama from employees where first_name = 'Den';
dbms_output.put_line('Nama adalah: ' || Nama );
for i in 1..3 loop
<< inner_loop >>
dbms_output.put_line('Nama saya berulang: ' || Nama );
end loop outer_loop;
end
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment