I've tried using the following:
select * from TABLE1 where COLUMN= :VAR union select * from TABLE2 where COLUMN= :VAR;
I'm getting the following error message back:
[Teradata Database] [TeraJDBC 14.10.00.26] [Error 3654] [SQLState HY000] Corresponding select-list expressions are incompatible.
If I just run:
select * from TABLE1 where COLUMN= :VAR;
then it works, but I need to be able to answer one prompt for the same variable that is used across multiple tables. I'm using Oracle SQL Developer Version 188.8.131.52