a bit naff. On a technical note , you do not waste space when using VARCHAR columns ( that is the whole point ). Ideally you should have pre-defined the table. Also, try loading say 1000,0000 rows this way or more. What about blobs/clobs and images ????
+Harry Buckley Thanks Harry, feedback is always needed to improve. I had thought the main difference was NULL value padding and that the DB may allocate blocks that then weren't used - not necessarily wasting space but not the most efficient use of disk. But something I can do some more reading on :) When it comes to importing 10,000,000 rows, with enough RAM it would handle it, but CLOBS, BLOBS etc I guess wouldn't generally be in excel/csv as a source anyway? I will be doing a video on using Excel to help write repetitive statements such as case whens and mass inserts so may be more interesting. My videos are generally pitched at the aspiring MI/BI analyst audiences Again, thanks for watching! If there is a type of content you would prefer to see, just let me know!
How to add constraints while using this method
really good one. Helped me.
nice video
sorry i cant read, which software you are using.?
+shahzad asgher pl/sql developer
a bit naff. On a technical note , you do not waste space when using VARCHAR columns ( that is the whole point ). Ideally you should have pre-defined the table. Also, try loading say 1000,0000 rows this way or more. What about blobs/clobs and images ????
+Harry Buckley Thanks Harry, feedback is always needed to improve. I had thought the main difference was NULL value padding and that the DB may allocate blocks that then weren't used - not necessarily wasting space but not the most efficient use of disk. But something I can do some more reading on :)
When it comes to importing 10,000,000 rows, with enough RAM it would handle it, but CLOBS, BLOBS etc I guess wouldn't generally be in excel/csv as a source anyway? I will be doing a video on using Excel to help write repetitive statements such as case whens and mass inserts so may be more interesting.
My videos are generally pitched at the aspiring MI/BI analyst audiences
Again, thanks for watching! If there is a type of content you would prefer to see, just let me know!