hello Forum,
I am new to Oracle.
I have a task to compile release scripts which consist of mostly ddl's statements: create package, create table, create view, create index and some data populations - insert's.
What I find challenging is that some statements need to be finalized with '/' ( create package, begin ... execute immediate ... end, create proc).
Other statements like create table, create view; need to be finalized by ';'.
It leads to confusion, ambiguity, lost time.
One of the rules is that repeated execution should not produce an error but skip or ignore execution.
Situation is getting more complicated because Toad script execution may not produce errors but sqlplus will.
Is there any simple and concise rules spelled which say: 'these statements need to be finalized by '/', other's by ';' '?
Is there any reason why sqlplus is not consistent as far as not having single statement / symbol being used to finalize statement executions?