Options
PL/SQL Formatter is easy to use tool to beautify PL/SQL code online. Copy, Paste and Beautify.
PL/SQL Beautifier
PL/SQL Beautifier is a set of tools that can be used to beautify and format the output of PL/SQL programs. It consists of a set of tools that can be used to beautify and format the output of PL/SQL programs.
It works by taking a program's source code and using it to generate a new program that rewrites the program's SQL statements into well-formed SQL statements, removes unused PL/SQL code and duplicated PL/SQL calls, adds comments to the SQL statements and adds additional formatting instructions to make the SQL statements more readable.
What can you do with PL/SQL Formatter?
- It helps to beautify your PL/SQL code.
- Paste the code at the left side pane and it will beautify the PL/SQL code on the right pane.
- PL/SQL Code Beautifier Online works well on Windows, MAC, Linux, Chrome, Firefox, Edge, and Safari.
PL/SQL Code Example:
DECLARE
CURSOR occupancy_cur IS
SELECT
pet_id,
room_number;
FROM
occupancy
WHERE
occupied_dt = TRUNC (SYSDATE);
occupancy_rec occupancy_cur % ROWTYPE;
BEGIN
OPEN occupancy_cur;
LOOP
FETCH occupancy_cur INTO occupancy_rec;
EXIT
WHEN occupancy_cur % NOTFOUND;
update_bill (occupancy_rec.pet_id, occupancy_rec.room_number);
END
LOOP
;
CLOSE occupancy_cur;
END;