I was wondering whether it was possible to use dynamic arrays in C or if not something which does the job of?
Here is my scenario. I am reading values (of which there are multiples) from an Oracle table. Each time I read a record i want to write it to another table, however I only want to do this if I haven't already written a record for that specific value. For this reason I wanted to write the value to an array and then check this array each time I read in a new record. My problem is that I have no idea how many unique values there are so I don't want to size the array at the start?
p.s. I cannot restrict my result set in oracle as there are other tables that I need to create for every record.
Any ideas would be much appreciated.