View Creation Multiply Database Columns

kevinn397 over 8 years ago

I get an error when I try to use multiplication of two columns from the same table of an Oracle database. I'm using the format (column1 * column2) AS column3 and I end up with an error that says, "You cannot perform a * query."

Discussion posts and replies are publicly visible

Parents

0 kevinn397 over 8 years ago

Hi,
Sanjay:
The datastore entites already exists and it's populated. The actual view CDT already exists too. the source of the issue is using the "*" symbol inside of Database Query Smart Service.
Vinayakb:
Not using the double quotes will cause the Smart Service to throw an error as far as I know. I'll try it without it and post results.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 kevinn397 over 8 years ago

Hi,
Sanjay:
The datastore entites already exists and it's populated. The actual view CDT already exists too. the source of the issue is using the "*" symbol inside of Database Query Smart Service.
Vinayakb:
Not using the double quotes will cause the Smart Service to throw an error as far as I know. I'll try it without it and post results.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data