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
Srinivas
checking for lower case
Srinivas
Count of 'A' from given string
Srinivas
Srinivas
myWorkbench
SQLWithOuterAndInnerLoop_UnableToExecute
Display the number value in Words
Oracle Sandbox: Dog Data