Requirement:
In Oracle, display the first row of data from a table with each data element separated by a delimiter.. The column names & number of columns in the table cannot be hardcoded as they are likely to change over time.
Real-life example:
Users provide a file of unknown format for input into your data model. You’ve built the data parsers already (more in this blog on that later), but you need to convert their format into your data model format before running the server processes. The data parsers end at the point of loading the data into a temporary staging table that is dropped & re-created as file-formats change.
Solution:
Oracle function that returns a delimited string representing one row of data. User passes in the table name, delimiter, and rowNumber:
Leave a Reply