Skip to content

Instantly share code, notes, and snippets.

@adityadaniel

adityadaniel/sql_last_name.sql

Created June 3, 2017 08:56
Show Gist options
  • Save adityadaniel/6eccf8ada2ea7d65d5cb5e1978f98d34 to your computer and use it in GitHub Desktop.
Save adityadaniel/6eccf8ada2ea7d65d5cb5e1978f98d34 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
sql_last_name.sql
declare
v_fname employees.first_name%type;
v_lname employees.last_name%type;
begin
SELECT first_name, last_name into v_fname, v_lname from employees WHERE last_name = 'Chen';
dbms_output.put_line('Nama lengkap saya adalah: ' || v_fname || ' ' || v_lname);
end;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment