Geek Answers Handbook

What does "/" do in PL / SQL?

I am looking at some PL / SQL code, and in the scripts I found the following:

/ SHOW error grant execute on someName1 to someName2; / SHOW error

Viewing the documentation for PL / SQL I could not find an explanation of what to do / do.

Can someone enlighten me?

  • Update: I opened a file that includes this script in SQL Developer for Mac. Compilation gives the error "met the character" / ". Should these slashes be removed?
+6
sql plsql plsqldeveloper
source share
2 answers

"/" executes the sql command in the current buffer. It is similar to GO SQL Server

+7
source share

The slash basically executes the last command stored in the buffer.

This is kind of a clumsy thing, but many PL / SQL interpreters / engines, such as SQL Plus, require you to enter "/" after each complete statement in order to actually execute it and see the results.

http://download.oracle.com/docs/cd/B28359_01/server.111/b31189/ch12004.htm#SQPUG162

+4
source share

More articles:


All Articles