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 vinayakb over 8 years ago

can you try adding space here "r"."probability"*"r"."impact" for the star sign. Also, is it necessary to add the query in double quotes?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 vinayakb over 8 years ago

can you try adding space here "r"."probability"*"r"."impact" for the star sign. Also, is it necessary to add the query in double quotes?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data