Skip to Main Content
Forums

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

843798
Which class was not found?
843798
no, and on my machine even Java-1.5 is detecting proxy-settings automatically.
843798
Which class was not found?
The class specified in the code parameter of the Applet tag, which is loaded to start the applet.

Thanks.
843798
no, and on my machine even Java-1.5 is detecting
proxy-settings automatically.
Thanks for the info. I probably should have been more specific in regards to web browser and o/s.

My O/S is Windows2000 Pro (with SPs). The failures occur using IE 6 and the "Automatically detect settings" LAN/Network setting; and with Mozilla Firefox 1.0.3, using the "Auto detect proxy settings for this network" Connections settings. Both these browsers worked with these settings when using the JRE 1.4.2*

Thanks.
796365
Here's the proxy documentation for Java 5: 
http://java.sun.com/j2se/1.5.0/docs/guide/deployment/deployment-guide/proxie_config.html
843798
Chuck,

Thanks a lot for the link. However, comparing it with the same from the 1.4.2 docs, I don't see any major differences that would explain why what once worked in the 1.4.2 environment no longer does in the 1.5 JRE (nothing new in 1.5 Deployment that I found). I found nothing in the 5.0 release notes/compatibility info either that would explain this. Maybe JRE 1.5 is just enforcing now what has always been documented?

If you come across any other sources I can investigate, let me know. I'm mainly trying to come up with a fact-based technical story for our hundreds of customers that are going to blame our product Applet for suddenly not working in the JRE 1.5.

Thanks for your help.

Craig
796365
This may not be relevant. It's an excerpt from a Sun chat session.

SDN Chat Sessions
Java Plug-In Technology
SDN Chat Sessions Transcripts Index

April 12, 2005
Guests: Dennis Gu, Calvin Cheung, and Danielle Pham
Moderator: Edward Ort (MDR-EdO)
...

Tom: I have "Automatically detect settings" selected in IE for proxy but I cannot get plug-in to work. Other proxy settings work fine though. Why?

Dennis Gu: Well, because JRE doesn't support it yet. The good news is that we are working on this feature in JRE 6.0.
1 - 7

Post Details

Added on Aug 21 2019
#sql-pl-sql
12 comments
2,879 views