This is similar to "Oracle Nasty Dates Finder for .NET folks!" but this time it is for numbers instead of dates! I ran into this issue as I was moving data from Oracle to SQL Server. So, you are working with Oracle using ODP.NET and you have a simple, straight-forward SELECT * FROM TABLE; Alternatively, … Continue reading Oracle ODP.NET: Resolve “Arithmetic operation resulted in an overflow” or “Specified cast is not valid”
Why DELETE is bad? In Oracle, when it comes to deleting ** A L L ** the data from a table (clearing the contents of a staging table for example), using a DELETE statement is the most inefficient choice. Here are some reasons why DELETE is bad It uses UNDO It uses REDO It fires … Continue reading Oracle – TRUNCATE vs DELETE – Spoiler: TRUNCATE Wins & Why? Hours vs Seconds!