Advertisement
Guest User

Untitled

a guest
Apr 27th, 2017
53
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.24 KB | None | 0 0
  1. create or replace FUNCTION extraer_codigo (nombre EMP.ENAME%TYPE, codigo EMP.EMPNO%TYPE)
  2. RETURN VARCHAR2
  3. IS
  4. vUsuario VARCHAR2(150);
  5. BEGIN
  6. vUsuario := (SUBSTR(nombre,1,4) ||'_' || TO_CHAR(codigo));
  7. RETURN vUsuario;
  8. END extraer_codigo;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement