Hi All,
I have created the shell script , inside i have called the select statement for generating sql tuning task output. after generation of o/p is in wrapped mode and alignment also not in proper .
shell script
generate_tuning_task ()
{
sqlplus -s <<-EOF
${PBDW_USERID}/${PBDW_PWD}@${PBDW_SID}
DEFINE TASK_ID=$1
SET trimspool ON
SET wrap off
SET heading off
SET linesize 300
SET echo off
SET pages 999
SET long 2000000000
Col object_type format a10000
Col object_name format a10000
Col owner format a10000
SELECT DBMS_SQLTUNE.REPORT_TUNING_TASK('&&TASK_ID') AS RECOMMENDATIONS FROM DUAL;
EOF
}
current O/p:
Kindly advise , is there any set command to adjust the o/p ?.