Tuesday, 10 September 2013

How to select all the columns without the timestamp and date types?

How to select all the columns without the timestamp and date types?

I'm comparing two tables which have a lot of columns. I'm interested in
all the columns except the timestamps and dates.
I'm doing this:
select row1, row2, row3, row4, ..., row39, row40
from mytable1
minus
select row1, row2, row3, row4, ..., row39, row40
from mytable2;
I select all the columns one by one, except the three which are dates and
timestamp.
How I can simplify all this to not have to put all the colunms one by one?

No comments:

Post a Comment