Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- create or replace FUNCTION generarUsuarios (nombre VARCHAR2, codigo INT)
- RETURN VARCHAR2
- IS
- vUsuario VARCHAR2(150);
- BEGIN
- vUsuario := SUBSTR(LOWER(nombre),1,4) ||'_' || TO_CHAR(codigo);
- RETURN vUsuario;
- END generarUsuarios;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement