DecodeCodeId


<DEFAULT SERVER>   >   <DEFAULT DATABASE>   >   <DEFAULT SCHEMA>   >   SALEORDER   >   DecodeCodeId   

Function body DecodeCodeId(codeId INTERGER) return DecodeCodeId, Package SALEORDER

Name Datatype Precision Description
codeId interger INTERGER, parameter of SALEORDER.DecodeCodeId
Name Types Value
No Data
Name Definition
No Data

function DecodeCodeId(codeId interger) return nvarchar
	is
		
	begin
		return(DECODE(codeId,'r1','Revenue','e1','Expense'));
	end

     
Name Types Description
DECODE Function PL/SQL System Function
<DEFAULT SCHEMA>.SALEORDER.DecodeCodeId Function Function interface DecodeCodeId(codeId INTERGER) return NVARCHAR, Package SALEORDER
INTERGER Undefined Item
NVARCHAR Undefined Item

     
No Data