SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Difference between ';' and '/' in the SQL scripts

EV259May 12 2013 — edited May 13 2013

Hi All,

Could anyone please let me know the difference between placing ';' and '/' in the sql scripts.

I am placing couple of insert statements in a textfile with .sql extension and running it from the sql prompt.

Which one( ';' or '/') should be keep at the end of each statement in the script.

SQL> SELECT SYSDATE FROM DUAL;

SYSDATE
---------
12-MAY-13

SQL> SELECT SYSDATE FROM DUAL
  2  /

SYSDATE
---------
12-MAY-13

Thanks,

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 10 2013

Added on May 12 2013

6 comments

1,415 views