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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
SQL*PLUS formatting issues, can't use || to concat fields
Hey everyone. Carp, you're right, the GROUP BY is definitely needed. I tried removing it just to see if I could get the concat operator to work right and did but got back a huge difference in the results. I added the GROUP BY back in and it actually worked. I only had issues with columns...- Zike
- Post #10
- Forum: Oracle: All versions
-
SQL*PLUS formatting issues, can't use || to concat fields
Ok, sorry for the long delay in a reply. I have been looking at using the COLUMN directive to get the lengths cut down to appropriate sizes but here's the problem. I'm running a "select max(length(column_name)) from table" and that works fine, and I get a certain length for the column. The...- Zike
- Post #7
- Forum: Oracle: All versions
-
SQL*PLUS formatting issues, can't use || to concat fields
Ok, Here's the script and query (made it generic so I could post it here). The &1 is just the sysDate from the beginning script that is being passed to all the subscripts. SPOOL /home/user/sql/out/test.&1..txt APPEND SET TERMOUT OFF SET TRIMSPOOL ON SET TRIMOUT ON SET LINESIZE 1024 SET...- Zike
- Post #3
- Forum: Oracle: All versions
-
SQL*PLUS formatting issues, can't use || to concat fields
Ok, Here's my issue. I'm redoing a set of queries to produce reports from a manual process to an automated process. The requirement was that I use SQL*PLUS to produce to reports. I can get the queries to produce the reports using SPOOL with several SET options. I get close to matching the...- Zike
- Thread
- Replies: 10
- Forum: Oracle: All versions
