OraFAQ Forum: Client Tools » No Semi-colon used in buffer editor Sqlplus

Home » Other » Client Tools » No Semi-colon used in buffer editor Sqlplus (oracle 11g_2, windows 7)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

No Semi-colon used in buffer editor Sqlplus [message #592935]

Tue, 13 August 2013 03:36

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??

/forum/fa/11061/0/

Attachment: 13-08-2013 1-56-50 PM.png
(Size: 12.36KB, Downloaded 1206 times)

Report message to a moderator

Re: No Semi-colon used in buffer editor Sqlplus [message #592950 is a reply to message #592935]

Tue, 13 August 2013 04:32

Michel Cadot
Messages: 68501
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

Report message to a moderator

Re: No Semi-colon used in buffer editor Sqlplus [message #593110 is a reply to message #592935]

Wed, 14 August 2013 03:27

gazzag
Messages: 1114
Registered: November 2010
Location: Bedwas, 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

Report message to a moderator

Re: No Semi-colon used in buffer editor Sqlplus [message #593111 is a reply to message #593110]

Wed, 14 August 2013 03:30

gazzag
Messages: 1114
Registered: November 2010
Location: Bedwas, UK

Senior Member

Michel,

Do you ever consider that just because you don't consider a question relevant doesn't render it invalid?

Report message to a moderator

Re: No Semi-colon used in buffer editor Sqlplus [message #593118 is a reply to message #593111]

Wed, 14 August 2013 04:44

Michel Cadot
Messages: 68501
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

gazzag
Messages: 1114
Registered: November 2010
Location: Bedwas, UK

Senior Member

I assumed it was merely a language/translation problem. My mistake.

Report message to a moderator

Re: No Semi-colon used in buffer editor Sqlplus [message #595596 is a reply to message #593120]

Thu, 12 September 2013 04:44

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Sep 24 16:34:56 CDT 2023