Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How to remove space when spool data to textfile
Hi JarlH, Thank you for your reply and help. I able to solve the problem, but i keep get this error message "ORA-01445: Cannot select ROWID from, or sample, a join view without a key-preserved table" when i do inner join table. the SQL as follow:- SELECT LPAD(a.Branch, 3, '0')|| CASE WHEN... -
How to remove space when spool data to textfile
Hi, I try to spool data from database to textfile. My coding as below, but the problem now i cannot remove the space in text file. The output will be like this:- Sample Output: 282|282000000792007 |23102007 | 1 The output that i want is like this:-...
