Home » SQL & PL/SQL » Client Tools » No Semi-colon used in buffer editor Sqlplus (oracle 11g_2, windows 7)
No Semi-colon used in buffer editor Sqlplus [message #592935] Tue, 13 August 2013 03:36 Go to next message
robinpoulose
Messages: 1
Registered: August 2013
Junior Member
Normally we use ; while we end the SQL statement or FROM clause.

However while we edit in buffer editor we dont use semicolon to end the statement .


example : afiedt.buf (editor)

select employee_id , first_name, last_name, email, phone_number
from employees
/

Here, we don't use semicolon , can any one justify why??

./fa/11061/0/
Re: No Semi-colon used in buffer editor Sqlplus [message #592950 is a reply to message #592935] Tue, 13 August 2013 04:32 Go to previous messageGo to next message
Michel Cadot
Messages: 58616
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There is no reason.
It is as it is.
What is your concern?
Explain your question.

Regards
Michel
Re: No Semi-colon used in buffer editor Sqlplus [message #593110 is a reply to message #592935] Wed, 14 August 2013 03:27 Go to previous messageGo to next message
gazzag
Messages: 276
Registered: November 2010
Location: Bristol, UK
Senior Member
When you type in a statement with no semi-colon, the statement is simply loaded into the buffer. You can display the buffer by typing "list" or simply "l". Then you type a forward slash ("/") to run it.

However, if you end the statement with a semi-colon (";") this has the effect of loading it into the buffer and running it.

So these two statements are the same:

SQL> select * from dual
2  /
D
-
X


and

select * from dual;
D
-
X


HTH
-g
Re: No Semi-colon used in buffer editor Sqlplus [message #593111 is a reply to message #593110] Wed, 14 August 2013 03:30 Go to previous messageGo to next message
gazzag
Messages: 276
Registered: November 2010
Location: Bristol, UK
Senior Member
Michel,

Do you ever consider that just because you don't consider a question relevant doesn't render it invalid?
Re: No Semi-colon used in buffer editor Sqlplus [message #593118 is a reply to message #593111] Wed, 14 August 2013 04:44 Go to previous messageGo to next message
Michel Cadot
Messages: 58616
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You didn't answer the question "can any one justify why??"
So your answer is invalid, isn't it? Twisted Evil

Regards
Michel

[Updated on: Wed, 14 August 2013 04:45]

Report message to a moderator

Re: No Semi-colon used in buffer editor Sqlplus [message #593120 is a reply to message #593118] Wed, 14 August 2013 05:55 Go to previous messageGo to next message
gazzag
Messages: 276
Registered: November 2010
Location: Bristol, UK
Senior Member
I assumed it was merely a language/translation problem. My mistake.
Re: No Semi-colon used in buffer editor Sqlplus [message #595596 is a reply to message #593120] Thu, 12 September 2013 04:44 Go to previous message
pradip.tk
Messages: 3
Registered: July 2013
Location: India
Junior Member
I think, when you edit it,PL/SQL takes and executes it as a block, hence / is required.


rgds
Pradeep

[Updated on: Thu, 12 September 2013 04:45] by Moderator

Report message to a moderator

Previous Topic: How to replicate a package in one database to other database
Next Topic: Question Regarding Line Numbering For SQL Developer
Goto Forum:
  


Current Time: Wed Jul 30 02:42:18 CDT 2014

Total time taken to generate the page: 0.11159 seconds