rules repository

G-7125 – Always use CREATE OR REPLACE instead of CREATE alone.

Using `create` alone makes your scripts give an error if the program unit already exists, which makes the script not repeatable. It is good practice to use `create or replace` to avoid such errors. This rule applies to the following SQL statements: - `create package` - `create package body` - `create function` - `create procedure` - `create trigger` - `create type` - `create type body` - `create view`

Tags: Stored Object.

Quality area: Maintainability. Severity: Major. Fixing time: Local-easy.

No rule selected