GetFullName


<DEFAULT SERVER>   >   <DEFAULT DATABASE>   >   <DEFAULT SCHEMA>   >   CUSTOMERS   >   GetFullName   

Function body GetFullName(fname NVARCHAR2,lname NVARCHAR2) return GetFullName, Package CUSTOMERS

Name Datatype Precision Description
fname nvarchar2 NVARCHAR2, parameter of CUSTOMERS.GetFullName
lname nvarchar2 NVARCHAR2, parameter of CUSTOMERS.GetFullName
Name Types Value
No Data
Name Definition
No Data

function GetFullName(fname in nvarchar2,lname in  in nvarchar2) return nvarchar
	is
	begin
		-- Check the employee
		RETURN(CONCAT(CONCAT(fname,', '),lname)); 
	end GetFullName

     
Name Types Description
CONCAT Function PL/SQL System Function
<DEFAULT SCHEMA>.CUSTOMERS.GetFullName Function Function interface GetFullName(fname NVARCHAR2,lname NVARCHAR2) return NVARCHAR, Package CUSTOMERS
NVARCHAR2 PL/SQL System type PL/SQL System Object
NVARCHAR Undefined Item

     
Name Types Description
<DEFAULT SCHEMA>.TRG_ORDER Trigger Simple Trigger of BEFORE "INSERT on sales_order_items"
<DEFAULT SCHEMA>.PRODUCTS.ProductsByCustomer Procedure Procedure body ProductsByCustomer(Customer_Id NUMBER), Package PRODUCTS