Home » SQL & PL/SQL » Client Tools » Difference between slash and semicolon
Difference between slash and semicolon [message #481948] Mon, 08 November 2010 09:31 Go to next message
Database admin
Messages: 365
Registered: September 2006
Location: india
Senior Member



Hi,

I have one question regarding slash ( / ) and semicolon ( ; ) in sql statements.

Can somebody differentiate about it?

Thanks
Re: Difference between slash and semicolon [message #481951 is a reply to message #481948] Mon, 08 November 2010 09:37 Go to previous messageGo to next message
Michel Cadot
Messages: 66654
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
For SQL*Plus, none.

Regards
Michel
Re: Difference between slash and semicolon [message #482007 is a reply to message #481951] Tue, 09 November 2010 01:08 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
There is a slight difference (at least in 10.2.0.1.0):
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Nov 9 08:06:40 2010

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

SQL> connec scott/tiger
Connected.
SQL> select * from dual;

D
-
X

SQL> ;
  1* select * from dual
SQL> ;
  1* select * from dual
SQL> /

D
-
X

SQL> /

D
-
X

If entered after a statement, a slash and a semicolon act alike. However, when entered after EXECUTING a statement, their behaviour differ.

[Updated on: Tue, 09 November 2010 01:09]

Report message to a moderator

Re: Difference between slash and semicolon [message #482192 is a reply to message #482007] Wed, 10 November 2010 04:57 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
I guess it depends on the terminator defined at sql*plus
Re: Difference between slash and semicolon [message #482231 is a reply to message #482192] Wed, 10 November 2010 08:37 Go to previous messageGo to next message
Michel Cadot
Messages: 66654
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
';' depends on sqlterminator parameter, good reminder, '/' does not.

Regards
Michel
Re: Difference between slash and semicolon [message #482240 is a reply to message #482231] Wed, 10 November 2010 09:24 Go to previous message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Smile Utilizing the oppurtunity At a Right time

Sriram
Previous Topic: Toad and Team Foundation System 2010: VCS archive is empty
Next Topic: Spool Error in SQL*Plus
Goto Forum:
  


Current Time: Wed Oct 23 05:17:37 CDT 2019