{ }

PL/SQL Code Assembler

HealthOne Stored Procedure Training Lab

Score

Level

Streak

0 🔥

🎯

Challenge

Loading challenge...

🧩

Code Blocks

📄 procedure.sql

Drag code blocks here to build your stored procedure

💡 Hint

Hint will appear here...

📺 Expected Output (When Run)

-- Output will appear here

📚 PL/SQL Quick Reference

Procedure Start

CREATE OR REPLACE PROCEDURE

Parameters

(param IN datatype)

Begin Block

AS BEGIN ... END;

Output

DBMS_OUTPUT.PUT_LINE()

Conditional

IF ... THEN ... END IF;

Loop

FOR rec IN cursor LOOP

🎓

Tip: PL/SQL procedures always start with CREATE OR REPLACE PROCEDURE and end with END;

Excellent!