The input table for this example is like the input table for the previous example, except that no delimiter separates the virtual columns in the packed data. To enable the function to determine the virtual columns, the function call specifies the column lengths.
| sn | packed_temp_data |
|---|---|
| 10 | NashvilleTennessee35.1 |
| 11 | NashvilleTennessee36.2 |
| 12 | NashvilleTennessee34.5 |
| 13 | NashvilleTennessee33.6 |
| 14 | NashvilleTennessee33.1 |
| 15 | NashvilleTennessee33.2 |
| 16 | NashvilleTennessee32.8 |
| 17 | NashvilleTennessee32.4 |
| 18 | NashvilleTennessee32.2 |
| 19 | NashvilleTennessee32.4 |
| 20 | Thisisbaddata |