In Domo Workbench select column, * not returning data

BrianM

I'm new to Domo and Oracle SQL having worked in MS SQL Server until recently. In Domo workbench 'Select column, T.* from Table T' doesn't return any rows of data in the preview window. 'But Select column from Table T' and 'Select T.* from Table T' both do return rows for the preview. I thought my issue might be PL/SQL related but the use of the alias should work in PL/SQL as it does in T-SQL form the posts I've been able to find. Any help on what I'm missing in the syntax translation would be appreciated.

ggenovese

Just a guess, but could it be that you have duplicate column names? Instead of

SELECT column, T.* FROM TABLE T 

can you try

SELECT column as uniquely_named_column, T.* FROM TABLE T

ggenovese

Just a guess, but could it be that you have duplicate column names? Instead of

SELECT column, T.* FROM TABLE T 

can you try

SELECT column as uniquely_named_column, T.* FROM TABLE T

BrianM

That solved the issue. Thanks for the help!