I am trying to spool the contents of a table using a WHERE clause. The table has 22 fields. While the statement executes without any problems, the spooled file shows only values for the first 17 columns.There is data in the last 5 fields too.If I do a simple select, i get all the 22 fields' data.
The same procedure when repeated for another table containing 20 fields, the output in the spool file shows all 20.
Can sombody be able to tell me what may be the problem with the first table?