Toad World® Forums

views - use same column twice in one view


#1

How can one create a view in the TDM GUI where a parent column is used twice, each with a unique alias. SQL-wise, this would look like

CREATE VIEW FUTILE(X1,X2) AS SELECT DUMMY, DUMMY FROM DUAL;

The current GUI seems to only allow one copy of a column to be used for a query.

Thanks.


#2

Hello,

Unfortunately, it is not possible for now. However, we will deal with it for any of future TDM releases.

At the moment you can have the view only as a text:

  1. Edit the view and on tab General, select the “SELECT in Views as Text” checkbox.
  2. On tab SQL write “AS SELECT DUMMY, DUMMY FROM DUAL”.

If you have more questions, please write us back.

Regards, Vladka + TDM Team