PL/SQL Substitution Variables


declare
  v_employee_id number:=&sv_employee_id;
  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=v_employee_id;

  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 such employee');
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"