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:
- Result of the drop procedure command
- Result of the create procedure command
- Result of the procedure call