Advertisement
iannis123

Untitled

Apr 17th, 2018
95
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.39 KB | None | 0 0
  1. CREATE FUNCTION numar_litere5(p_litere IN VARCHAR2)
  2. RETURN INTEGER IS
  3.   nr_litere INTEGER;
  4. BEGIN
  5.   SELECT LENGTH(p_litere) INTO nr_litere FROM DUAL;
  6.   RETURN nr_litere;
  7. END;
  8.  
  9. DECLARE
  10.   contor INTEGER;
  11.   pe_litere VARCHAR2(20);
  12. BEGIN
  13.   pe_litere :='OsamaBinLaden';
  14.   contor:= numar_litere5(pe_litere);
  15.   DBMS_OUTPUT.put_line('Cuvantul ' || pe_litere || ' are ' || contor || ' litere');
  16. END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement