PL/SQL Formatter.

PL/SQL Formatter Online | PL/SQL Beautifier Online

Written by
Vinish Kapoor is a seasoned software development professional and a fervent enthusiast of artificial intelligence (AI). His impressive career spans over 20 years, marked by a relentless pursuit of innovation and excellence in the field of information technology. As an Oracle ACE, Vinish has distinguished himself as a leading expert in Oracle technologies, a title awarded to individuals who have demonstrated their deep commitment, leadership, and expertise in the Oracle community.

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;

Also Try: