SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL QUERY OUTPUT FORMAT

3543055Jan 31 2018 — edited Jan 31 2018

HI,

I have SQL query written which display tablespaces exceeding threshold. Output is sent to mail box via shell script.

Script runs fine but output format for columns displayed in email is not aligned.

I tried to fixed space by using RPAD & LPAD functions but that didn't worked.

can you please advise ?

Below is the output I am getting.

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 28 2018

Added on Jan 31 2018

4 comments

555 views