Oracle – Quick Tip – Zero=One Trick To Generate Table Structures Dynamically From SELECT Statements!

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 …

Advertisement