PL/SQL Select Statement


declare
  v_first_name varchar2(35);
  v_last_name varchar2(35);
begin
  select first_name, last_name
  into v_first_name, v_last_name
  from employees
  where employee_id=100;

  dbms_output.put_line('Employee name: '||v_first_name||' '||v_last_name);
  exception
    when no_data_found then
      dbms_output.put_line('There is no employee with '||' employee id 100');
end;

Comments

Popular posts from this blog

Solution for "Can not obtain Oracle client information from registry"

Solution for the fault: "System.Diagnostics.Process.Start is not working on IIS, but working on ASP.NET Development Server"