>> I then realised that Oracle SQL Developer was only copying 200 lines/records from any column I selected
We don't fetch the entire result-set when you run a query or browse a table. We get the records in batches. Sounds like your default array size is set to 200 records. You can fetch all the records by using ctrl+end in the grid.