Em 15-10-2015 17:32, Norman Dunbar escreveu: > Hi Adriano, > >> Oracle uses something that I didn't understand exactly, wanting a '/' >> after some commands. That has no (clear) logic. > > A wee bit off topic, hopefully Helen won't mind/notice! > > In SQL*Plus each statement is terminated by either a ; or a /. Either > one means "execute now". The / has the additional purpose of > re-executing the previous statement. > > When entering PL/SQL, the programming language statements, each is > terminated by a ; so the / terminates and executes the PL/SQL. > > No set term is required. These are the default terminators, and > effectively, for Oracle, the only two required. > > In summary, for SQL, use either ; or / to terminate and execute while > for PL/SQL, the statement terminator is ; and the / executes. >
My "maybes" was mainly for CREATE TYPE, with AFAIR always requires a "/". That may be because non-simple (with methods) CREATE TYPE may have internal semicolons. It's a bit weird, anyway. Adriano ------------------------------------------------------------------------------ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
