• What’s this Oracle substring mean?

    I get this substring from string which is separated by (-) in below string. 911423900006406-417020016-17020016HOS70515010-USPCiTsLaSh003340695 Anyone know what this means?

    anuj2415 pointsBadges:
  • Sum of integer in table with .dbf format

    I have table with .dbf format..inside only have 30 records which are 239,45,340,...etc. I wan to sum the integer like this..for example the first number..239=2+3+9=14..and the second number 4+5=9..then the output is 14,9,...until the 30th number..How would i do it? Help is desperately needed..I...

    Quinten15 pointsBadges:
  • Substring A Packed Field

    Hello I have a flat record format that I move into an external data structure. Within the external data structure, I have many packed fields. Rather than refer to each of pacekd field by external field name, I would like to be able to substring each packed field out, and then, move the value of...

    Piano520 pointsBadges:
  • Why doesn’t the substring of a large field in CLLE program work correctly?

    I have a CLLE program in which I pass two parameters, the first is a one character field, the second is a 600 character field. When run, the parameters come in correctly. But when I substring the second parameter into 40 fifteen character pieces it gives me a CPF0804 error half way through the...

    Rick53110 pointsBadges:
  • Concatenation

    I am using "substring(concat('00'...." within my SQL select for a date query. However, the date 10 and higher is being overridden with "0". How do I prevent this from happening?

    BGramby15 pointsBadges:

    I need to get cities' name from a format like this: Los Angeles, CA New Orleans, LA etc.. I've tried: substr(a.air_location, -4) but that gives me the opposite...", LA" Any suggestions? Thanks.

    Antgaudi5 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.