CGI/Perl Guide | Learning Center | Forums | Advertise | Login
Site Search: in

  Main Index MAIN
INDEX
Search Posts SEARCH
POSTS
Who's Online WHO'S
ONLINE
Log in LOG
IN

Home: Perl Programming Help: Beginner:
Strange line in the code

 



digioleg54
User

Nov 17, 2017, 1:27 PM

Post #1 of 2 (979 views)
Strange line in the code Can't Post

I have a line:

Code
 my ($sql) = (q{SELECT type_cd,sec_cd||'|'||type_sub_cd FROM dte_security_types WHERE type_cd LIKE 'MARG_USD%'});


What is

Code
||'|'||


Thanks


Laurent_R
Veteran / Moderator

Nov 18, 2017, 2:56 AM

Post #2 of 2 (969 views)
Re: [digioleg54] Strange line in the code [In reply to] Can't Post

|| is the concatenation operator under some SQL implementations, especially Oracle. In this case, it concatenates the value of sec_cd and type_sub_cd with a | separator in between.

 
 


Search for (options) Powered by Gossamer Forum v.1.2.0

Web Applications & Managed Hosting Powered by Gossamer Threads
Visit our Mailing List Archives