Does anyone know if there's a way to specify which fields to exclude from an SQL rather than which fields to include?
For example, let's say I have 10 fields and I want to only include the first 9 in my SQL, then I could write the following:
Select COL1,COL2,COL3,COL4,COL5,COL6,COL7,COL8,COL9 from my_table where ...
However, a way to specify "all but col10" would be very handy for me and would speed some up my loops tremendously by not having to make extra copies of large files.
I'm hoping there's something very simple along these lines:
Select * not col10 from my_table where ...
Select *,-col10 from my_table where ...
Many thanks in advance,