PL/SQL Concat & Create Concat View


select concat(concat(first_name, ' '), last_name)
as "Name_Surname"
from employees
where employee_id = 152;
 

create or replace force view vew_emp_full_name
as
select concat(concat(first_name, ' '), last_name)
as "Name_Surname",
manager_id+department_id
as "Total"
from employees;

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"