Link to home
Start Free TrialLog in
Avatar of Medicine1
Medicine1Flag for United States of America

asked on

Query substr

Can someone explain what this line below is accomplishing. I am fairly new to PLSQL.  

substr(max((lpad(percent,10,'0') | | line_num)),11,6)
ASKER CERTIFIED SOLUTION
Avatar of Sean Stuber
Sean Stuber

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Medicine1

ASKER

Is the | | (bars) combining the numbers?
Avatar of Sean Stuber
Sean Stuber

yes, that's the string concatenation symbol