I have created a procedure which fires a SQL and writes the result of the query into a file.
I want the file written to be of a fixed size say 1500 bytes.
To produce a file of fixed size, I will have to create a file of fixed width (columns) and height (rows)
For this, I have been able to produce fixed column size by using rpad on each column of the query.
As the result set produced by the query can vary on day to day basis, how do I produce a file of fixed height