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