Run SQL thru shell script: how to get a new line when run sql query?

view full story

http://www.unix.com – Hi, this's Pom. I'm quite a new one for shell script but I have to do sql on shell script to query some information from database. I found a concern to get a new line...When I run my script, it retrieves all data as wondering but it's shown in one line :( What should I do? I'm not sure that I did set the statements correctly. Please kindly to suggest me ;( Thanks~ ============================================ Code: ============================================ #!/bin/bash suc_num=`$PATH/sqlplus -s xx/yyy@service_name << ! set echo off set feedback off set heading off set pagesize (HowTos)