A right function for Oracle

				
--**************************************
-- Name: A right function for Oracle
-- Description:The purpose of this tiny code snippet is to build a right function for Oracle which is used commonly in SQL Server.
-- By: barkýn ünüulu
--
-- Inputs:There two parameters for the Right function. One is the Original string which is to be trimmed and the other one is the number of characters which will be used for the right function.
--
-- Returns:It returns a varchar2 value.
--
--This code is copyrighted and has-- limited warranties.Please see http://www.Planet-Source-Code.com/vb/scripts/ShowCode.asp?txtCodeId=1184&lngWId=5--for details.--**************************************

create or replace function Right (Original_Char varchar2 ,Num_Char int) return varchar2 is
 result varchar2(255);
 neg_Num_Char int;
 begin
 
 neg_Num_Char := (-1)*karakter;
 Result := substr(Original_Char,neg_Num_Char,Num_Char);
 return Result;
 end;