Now we need to split this field into 5 new fields, named Srllno1 to Srllno5, with values of the 1st to 4th string and the 5th to last string after splitting the original field. Fill in null when the ...
@%1-3 are variables that's replaced by our system. So far so good. Here's the tricky part. A new requirement is to send a part of the JobNo (@%2), to another field as well, that we might call LineNo.
Does anyone know how I might split a string into an array in pl/sql? The kind folks at Oracle chose not to include that functionality in their language, and now I'm up a creek.<BR><BR>I need to split ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results