Perl Guru Forums: Perl Programming Help: Beginner: Strange line in the code

CGI/Perl Guide | Learning Center | Forums | Advertise | Login

Site Search: in


	MAIN INDEX	SEARCH POSTS	WHO'S ONLINE	LOG IN

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

digioleg54
User

Nov 17, 2017, 1:27 PM

Post #1 of 2 (3829 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 (3819 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)

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