Changing multiple actions chained into sqlplus to for loop in a bash script

Question

I have this script which is obviously inefficient:

#!/bin/sh
for i in $(seq 1 10);
do
  echo "CREATE TABLE testbenny_$i (id NUMBER NOT NULL);
  ! sleep 10
  select * from testbenny_$i;
  ! sleep 10
  select * from testbenny_$i;
  ! sleep 10
  select * from testbenny_$i;
  ! sleep 10
  select * from testbenny_$i;
  ! sleep 10
  DROP TABLE testbenny_$i;" | sqlplus system/passwd &
done

I have one repetitive action I tried to enclose in a FOR loop but couldn't.

  select * from testbenny_$i;
  ! sleep 10

I can't find the correct syntax to change it to a FOR. Working on Oracle 12.

Yeah, copied the example from there, though our needs are a bit different. — Evghen Tester
– Evghen Tester, Commented Nov 19, 2019 at 15:20

Popeye · Accepted Answer · 2019-11-19 14:37:53Z

1

Try the oracle sleep method as following:

#!/bin/sh
for i in $(seq 1 10);
do
  echo "CREATE TABLE testbenny_$i (id NUMBER NOT NULL);
  sys.DBMS_SESSION.sleep(10);
  Begin
  For var in 1..4 loop
  select * from testbenny_$i;
  sys.DBMS_SESSION.sleep(10)
  End loop;
  End;
  /
  DROP TABLE testbenny_$i;" | sqlplus system/passwd &
done

I have given just an example of how to use sys.DBMS_SESSION.sleep(10) method. Use it in your code according to your requirement.

edited Nov 19, 2019 at 14:37

user142162

answered Nov 19, 2019 at 13:28

Popeye

36k4 gold badges12 silver badges31 bronze badges

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

Collectives™ on Stack Overflow

Changing multiple actions chained into sqlplus to for loop in a bash script

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related