I have to prepare a plsql code by using collections data type to create the new data more than thousands (max 80000 records) for preparing a xls file to upload the file through loader.some column values in file would not be same for all records.
Format of column of file-
Action,accountid,record-type,account_type,account-no like 60 columns
Add,123,account1,A1,123…….
Add,234,account2,A1,234……
Modify,123,account1,A2,567……
Can I insert in some table through code and then copy in xls file manually or we can prepare an xls file also through code with data?
Please suggest.