Executing a multi line statement in SQL Plus on Unix

Question

I am trying to write a simple cursor and run it inside the command line Oracle client on Unix, SQL Plus. I have mostly been using single line statements and can't find a way to execute a multi line statement once I am done writing it. Can anybody help?

Here is my code:

DECLARE 
   TYPE array_t IS varray(4) OF varchar2(10); 
   ARRAY array_t := array_t('foo', 'bar', 'stack', 'overflow');
BEGIN 
   FOR i IN 1..array.count loop
       dbms_output.put_line(array(i)); 
   END loop; 
END;

Thanks

Nick Krasnov · Accepted Answer · 2012-10-01 18:43:35Z

13

To execute a PL/SQL block in SQL*PLUS, add slash at the end of the PL/SQL block:

SQL> DECLARE
  2     TYPE array_t IS varray(4) OF varchar2(10);
  3     ARRAY array_t := array_t('foo', 'bar', 'stack', 'overflow');
  4  BEGIN
  5     FOR i IN 1..array.count loop
  6         dbms_output.put_line(array(i));
  7     END loop;
  8  END;
  9  /

answered Oct 1, 2012 at 18:43

Nick Krasnov

27.3k6 gold badges66 silver badges81 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

amphibient Over a year ago

what is the difference between that and just typing . ? both seem to do the same thing

Nick Krasnov Over a year ago

Period(.) terminates PL/SQL mode but does not run a PL/SQL block whereas run command or slash / do.

FloorDivision Over a year ago

Also found that the / most definitely has to be on it's own line.

Collectives™ on Stack Overflow

Executing a multi line statement in SQL Plus on Unix

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related