Today, as I was working with a table and I needed to find the “archived” version of the table. Typically, the archive table would have a name with “Archive” suffixed to the actual table name. Since I could not find the archive table by just matching on the table name, I had to improvise. I … Continue reading SQL Server – Find Tables With Similar Table Structure
This is one of those ancient tricks that everybody discovers for themselves before knowing that it was common-knowledge already. Here is a simple scenario: How to efficiently create a table structure (with no data) based on a SQL SELECT statement which could potentially return millions of rows? Our Million Row Table - EMP_TEST Let us … Continue reading Oracle – Quick Tip – Zero=One Trick To Generate Table Structures Dynamically From SELECT Statements!