Skip to content

Instantly share code, notes, and snippets.

@bendem
Last active December 31, 2015 13:19
Show Gist options
  • Save bendem/7991920 to your computer and use it in GitHub Desktop.
Save bendem/7991920 to your computer and use it in GitHub Desktop.
Rot3 - PL/SQL.sql
-- ---------------------------------------------
-- @Author: bendem
-- @Date: 2013-12-13 10:13:47
-- @Last Modified by: bendem
-- @Last Modified time: 2013-12-16 19:34:14
-- ---------------------------------------------
CREATE OR REPLACE PROCEDURE rot3(
parm_str in varchar2,
parm_ret out varchar2
) is
begin
parm_ret := translate(parm_str,
'ABCDEFGHIJKLMNOPQRSTUVWXYZ',
'DEFGHIJKLMNOPQRSTUVWXYZABC'
);
parm_ret := translate(parm_ret,
'abcdefghijklmnopqrstuvwxyz',
'defghijklmnopqrstuvwxyzabc'
);
end rot3;
/
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment