OraFAQ Forum: SQL & PL/SQL » / (slash) character after END keyword

Home » SQL & PL/SQL » SQL & PL/SQL » / (slash) character after END keyword

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

/ (slash) character after END keyword [message #606077]

Sun, 19 January 2014 03:18

dancko
Messages: 108
Registered: June 2013
Location: italy

Senior Member

Hi at all,

i'm newbie in pl/sql programming.

Please, can anyone tell me what's the "/" (slash) character after END keyword of the pl/sql block?

Example:

DECLARE
-- some declaration
BEGIN
-- some statements
END;
/

thanks.

Report message to a moderator

Re: / (slash) character after END keyword [message #606080 is a reply to message #606077]

Sun, 19 January 2014 04:24

dariyoosh
Messages: 538
Registered: March 2009
Location: France

Senior Member

Hi,

The answer of your question is already in the documentation.
http://docs.oracle.com/cd/E11882_01/server.112/e16604/ch_four.htm#i1039663
Quote:

SQL*Plus treats PL/SQL subprograms in the same manner as SQL commands, except that a semicolon ( ; ) or a blank line does not terminate and execute a block. Terminate PL/SQL subprograms by entering a period (.) by itself on a new line. You can also terminate and execute a PL/SQL subprogram by entering a slash (/) by itself on a new line.
. . .
SQL*Plus stores the subprograms you enter in the SQL buffer. Execute the current subprogram with a RUN or slash (/) command. A semicolon ( ; ) is treated as part of the PL/SQL subprogram and will not execute the command.

For future reference: Oracle Database PL/SQL Language Reference

Report message to a moderator

Re: / (slash) character after END keyword [message #606081 is a reply to message #606080]

Sun, 19 January 2014 04:54

dancko
Messages: 108
Registered: June 2013
Location: italy

Senior Member

thank you so much.

Report message to a moderator

Previous Topic:	how to find last updated date
Next Topic:	SQL query

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 18:58:24 CDT 2024