How to get output like SQLPLUS while Running SQL Query in shell script

Question

I have a following shell script

RETVAL=`sqlplus -silent user/password <<EOF
SET PAGESIZE 9990

SELECT   id, type, count(*) "count" FROM event

EXIT;
EOF`

echo $RETVAL

it output like

ID TYPE count ------------- ---------- ----------- 2 11 2 1 4 1 2 10 29 1 1 35 2 1 6 2 18 1 2 2 3 7 rows selected

But i want output like

ID              TYPE        count
------------- ---------- -----------
        2         11           2
        1          4           1
        2         10          29
        1          1          35
        2          1           6
        2         18           1
        2          2           3

7 rows selected.

I tried to figure out if i get some new line character but couldnt find it.

Regards,

Mat · Accepted Answer · 2013-08-04 08:22:31Z

1

Your variable contains the newlines, but the way you're displaying it removes them.

Replace the echo statement with:

echo "$RETVAL"

The shell won't mess with the newlines then. You should pretty much always quote variables that can contain any form of whitespace that needs to be preserved.

answered Aug 4, 2013 at 8:22

Mat

208k41 gold badges407 silver badges423 bronze badges

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

Collectives™ on Stack Overflow

How to get output like SQLPLUS while Running SQL Query in shell script

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related