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;