Re: SQL*PLUS and Semicolons

When you do the File Open, SQL*Plus loads your script into the SQL*Plus buffer. SQL*Plus treats whatever is in the buffer as ONE SQL statement, hence no need for separators, although I believe that if you use a "/" it will execute the statement with no errors. File Open and Run are the equivalent of GET <script_name> and R[UN] (or /). If you have multi-statement SQL scripts, use _at_<script_name>.

I hope this helps.

Michael Serbanescu
Senior Consultant, MIACO Corporation    Received on Thu Apr 03 1997 - 00:00:00 CEST