Home » Online-Tools » PL/SQL Formatter Online | PL/SQL Beautifier Online

PL/SQL Formatter Online | PL/SQL Beautifier Online

By
| | | 














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;


Also Try: