Oracle stored Procedure Simple syntax

One, parameter-free stored procedure

--Create a stored procedure
Create or Replace procedure getdate as datetime varchar2 (+); begin    Select to_char (sysdate,'yyyy-mm-dd hh24:mi:ss' from dual;  Dbms_output.put_line (' current time:'| | datetime); end;

--Call the stored procedure

GetDate
End

Execution result output system current time

Ii. stored Procedures with parameters

 --Create stored procedure  
 Create or replace procedure Getnetworkid (FamilyID in   varchar2)  as   Networkid varchar2 ( 100  ); begin  select  f.cnetworkid into temp from   vav_radio_family f  where  f.cfamilyid=  FamilyID; Dbms_output.put_line (   region:  Span style= "color: #800000;" > '  | | networkid); end;  

--Call the stored procedure Begingetnetworkid (420530145); end;

Execution result, Output region

Three, the stored procedure with the output parameter

--Create a stored procedure
 out varchar2)  as begin Select  from dual;  Dbms_output.put_line (' current time:'| | datetime); end;
--Call stored procedure declare datetime varchar2;begin  Out_date (datetime); end;

Execution result, output system time

With Dbms_output.put_line (); --Print output results

Oracle stored Procedure Simple syntax