declare
ls_space varchar2(2);
begin
ls_space :=' '
select employee_id emp_id,last_name||ls_space||first_name name,
phone_number,email
from employees
ls_space varchar2(2);
begin
ls_space :=' '
select employee_id emp_id,last_name||ls_space||first_name name,
phone_number,email
from employees
-------
abc cdeSQL> select 'abc'||chr(32)||'cde' from dual;'ABC'||
-------
abc cde
2。last_name||chr(32)||first_name name