Compiling Objects When to use a slash ‚/‘
There was always a diffuse toppic for me in sqlscripts for sqlplus:
When to use a forwardslash (‚/‘) after a code-block and when not.
A simple marker:
Use a slash after every PL/SQL -block:
create or replace procedure procname as
Use NO slash after all DML -blocks:
– Materialized View
If there is an ‚Create or replace‘ in the first line of the code to compile there is no problem, but the object will be recreated unnecessarily.
But in the case of an index for example there will be an exception.