Additional
dbCAP
AnyDAC
ThinDAC
NCOCI8
Topic: use of smicolon at the end of an instruction
use of smicolon at the end of an instruction
Posted: 2003/05/27 21:18
 
SQL+ accept ';' at the end of each instruction as create table or alter or create procedure.

with OCI semicolon is prohibited for some instructions (select, create table...)and required for others (create procedure...).

Is it possible to accept ';' for each instruction?

Thanks
Philippe
RE: use of smicolon at the end of an instruction
Posted: 2003/05/28 09:23
 
I guess the answer is no.
You may try to use "execute immediate" inside anonymous PL/SQL block.
Waybe this way your code for OCI and SQLPlus will look the same.