Skip to Main Content

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

how to remove trailing white spaces in columns while using Spool

4068702Aug 21 2019 — edited Aug 21 2019

SET PAGESIZE 1000

SET COLSEP ,

SET WRAP OFF

SET HEADSEP OFF

SET UNDERLINE OFF

SET TRIMSPOOL ON

SET TRIMOUT ON

SET LINESIZE 2000

SET TERMOUT OFF

SET FEEDBACK OFF

SPOOL C:\Oracle\documents\emp.csv

SELECT * FROM EMP;

SPOOL OFF

Output is as following

EmployeeNumber,Employeename,EmployeeDepartment,EmployeeDesignation,EmployeeSalary

                    7657,             Andrew,                 Accounting,                                   ,               50000,

Comments

Patrick Wolf-Oracle
Answer

Hi,

you will have to refresh the Universal Theme of your old application to be able to use RTL. Go to Shared Components, Themes, pick the Universal Theme and then click the Refresh Theme button.

Regards

Patrick

Marked as Answer by IBRAHIM ALSRORI · Sep 27 2020
IBRAHIM ALSRORI

it's working now ,thank you patrick

mostafa3bdou

Dear Patrick,

I have the same problem but while attempting to apply the steps you've mentioned I got the below error:

1 error has occurred

  • ORA-00001: unique constraint (APEX_050100.WWV_FLOW_PAGE_PLUG_IDX2) violated

Thanks & Best Regards,

Mostafa M. Abdou.

IBRAHIM ALSRORI

Try first to change the Theme to default one,

Go to Shared Components, Themes,-Style- change it to (Vita) or your default theme,

then make a refresh .

regards

ibrahim alsrori

mostafa3bdou

Dear Ibrahim,

Still the error appears after applying your proposed solution .

Thanks & Best Regards,

Mostafa M. Abdou.

Pierre Yotti

I have the Same Error too. Somebody can help? please

egudai-Oracle

Followed Patrick solution ( Thanks Patrick )

See here :

https://www.youtube.com/watch?v=UzGu0t9fJqQ

1 - 7

Post Details

Added on Aug 21 2019
12 comments
2,908 views