I need to add a line with a slash after each paragraph in this script

Hi experts.
I have the following script (Is much longer than this, so I can't do it manually, ), and I have to add a line that will have only a slash after each paragraph:

The name of the script is test.sql.  
Aix 6.1

BEGIN DBMS_STATS.GATHER_TABLE_STATS(
                ownname => 'SYSADM'
                ,tabname => 'PSACCESSLOG'
                ,estimate_percent => NULL
                ,block_sample => FALSE
                ,method_opt => 'FOR ALL INDEXED COLUMNS'
                ,degree => DBMS_STATS.AUTO_DEGREE
                ,cascade => FALSE
         );END;

BEGIN DBMS_STATS.GATHER_TABLE_STATS(
                ownname => 'SYSADM'
                ,tabname => 'PSAPMSGPUBCON'
                ,estimate_percent => NULL
                ,block_sample => FALSE
                ,method_opt => 'FOR ALL INDEXED COLUMNS'
                ,degree => DBMS_STATS.AUTO_DEGREE
                ,cascade => FALSE
         );END;

BEGIN DBMS_STATS.GATHER_TABLE_STATS(
                ownname => 'SYSADM'
                ,tabname => 'PSAPMSGPUBERR'
                ,estimate_percent => NULL
                ,block_sample => FALSE
                ,method_opt => 'FOR ALL INDEXED COLUMNS'
                ,degree => DBMS_STATS.AUTO_DEGREE
                ,cascade => FALSE
         );END;
LVL 8
LindaCAsked:
Who is Participating?
 
woolmilkporcConnect With a Mentor Commented:
Assuming that the end of each paragraph is indicated by a line containing ");END;"

awk '{if ( $0~");END;") print $0 "\n/"; else print $0}' test.sql > new.test.sql
0
 
LindaCAuthor Commented:
Thank you!
0
All Courses

From novice to tech pro — start learning today.