Re^3: parse array to replace specific spaces with pipes

The simplest approach is to specify the list of columns concatenated with the '|' character - something like (I can't remember the exact syntax):

SELECT id + '|' + FirstName  + '|' + Surname
FROM some_table
WHERE ....
[download]

Otherwise, IIRC, you need to issue a set command (to set the column separator) prior to running the query - RTFM for further details.

A user level that continues to overstate my experience :-))

Comment on Re^3: parse array to replace specific spaces with pipes Select or Download Code

Replies are listed 'Best First'.
Re^4: parse array to replace specific spaces with pipes by Anonymous Monk on Jul 11, 2009 at 08:13 UTC
I whish I had time to RTFMFM. ;) All the manuals and tutorials work with small array examples and don't seem to teach much about moving data across scalar, arrays, or hashes...or, perhaps I'm reading the wrong books. The original sql+ query had a select statement that didn't work through the DBI interface. I think the DBI only uses standard SQL? `SQL statement SET HEADING OFF SPOOL file.txt SELECT 'NUMBER\|FIRST\|LAST\|ID' FROM DUAL; SELECT EMPLID \|\|'\|'\|\| FIRST_NAME \|\| '\|' \|\| LAST_NAME \|\| '\|' \|\| ID FRO +M db.VIEW WHERE (length(AS_UNIV_ID)>1) and (length(EMPLID)=9) and (le +ngth(FIRST_NAME)>1) and (length(LAST_NAME)>1); SPOOL OFF` [download] Best advise...kis. thx N	[reply] [d/l]

Replies are listed 'Best First'.

Re^4: parse array to replace specific spaces with pipes
by Anonymous Monk on Jul 11, 2009 at 08:13 UTC

I whish I had time to RTFMFM. ;) All the manuals and tutorials work with small array examples and don't seem to teach much about moving data across scalar, arrays, or hashes...or, perhaps I'm reading the wrong books.

The original sql+ query had a select statement that didn't work through the DBI interface. I think the DBI only uses standard SQL?

SQL statement
 SET HEADING OFF
 SPOOL file.txt
 SELECT 'NUMBER|FIRST|LAST|ID' FROM DUAL;
 SELECT EMPLID ||'|'|| FIRST_NAME || '|' || LAST_NAME || '|' || ID FRO
+M db.VIEW WHERE (length(AS_UNIV_ID)>1) and (length(EMPLID)=9) and (le
+ngth(FIRST_NAME)>1) and (length(LAST_NAME)>1);
 SPOOL OFF
[download]

Best advise...kis. thx N

[reply]
[d/l]