Stored procedures

Write / on an empty line to enter a stored procedure, stored function or database trigger.

Example

drop procedure if exists DEPT
/

create procedure DEPT()
begin
  select * from dept;
end
/

call DEPT()
/

Presuming table dept is available in the selected database, the code above will show three tabs:

1. Result of the drop procedure command
2. Result of the create procedure command
3. Result of the procedure call