Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
mr
CREATE OR REPLACE PROCEDURE insert_title (employee IN OUT VARCHAR2) IS BEGIN employee := 'Mr.' || SUBSTR(employee,1); END insert_title; / SET SERVEROUTPUT ON DECLARE employee_name VARCHAR2(15) := 'Smith'; BEGIN insert_title(employee_name); DBMS_OUTPUT.PUT_LINE(employee_name); END; /
run
|
edit
|
history
|
help
0
Count of 'A' from given string
record type
Addition of two numbers
oracle procedure example
Sush_emp_work
Srinivas
DBMS
Srinivas
factorial
checking for lower case