Create Or Replace Function Generateguid
Return Char Is
V_Guid Char(40);
Begin
Select Substr(Sys_Guid(),1,8)||'-'||Substr(Sys_Guid(),9,4)||'-'
||Substr(Sys_Guid(),13,4)||'-'||Substr(Sys_Guid(),17,4)||'-'
||Substr(Sys_Guid(),21) Into V_Guid...
There are a few ways to use functions.
Calling a function with an assignment statement
DECLARE
x NUMBER := functionName(); --functions can be called in declaration section
BEGIN
x := functionName();
END;
Calling a function in IF statement
IF functionName() = 100 THEN
Null;
EN...
