Executing the Oracle PL/SQL returns a number?

When you execute a PL/SQL script through sqlplus, if it returns a number at each line you press enter for a new line, it is beacuse you have forgot
to include '/' end of the script file for execute.


SQL> OracleScript.sql
       > 34
       > 35

So at this situation just enter '/'. Script will execute.

SQL> OracleScript.sql
       > 34 /

If you don't want to manually enter '/' here, place a '/' end of the script file. The script in here has a '/' end of the file which tells to execute it.


  1. Nice Post....:)I also got same experience. Backward slash indicates oracle engine that oracle PL SQL procedure has ended. I think it is good to add '/' to script file than adding it manually. It is safe.

    1. Thanks a lot Nadeesha, for sharing your information ! :)

  2. These bets have a 50% chance of winning every time, and you will want to wait in your first win earlier than transferring on to the following number in the sequence. When you lose a hand, you begin over at the minimum guess and go from there. In a bid to outfox Jarecki, casino owners rearranged his favourite roulette wheels in numerous spots every night time. But the professor 카지노사이트 knew every vein in the wood — every nic, crack, scratch, and discoloration — and he all the time ferreted them out. With his wife, Carol, he scouted dozens of wheels at casinos round Europe, from Monte Carlo , to Divonne-les-Bains , to Baden-Baden .


Post a Comment

Popular posts from this blog

PHP-SOAP web service with out a WSDL

How to add Maven dependency from a relative path referencing a local jar

Boomi Mapping - Removing special chars from an input