Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
15 replies
Subscribers
4 subscribers
Views
7509 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Process
View Creation Multiply Database Columns
kevinn397
over 7 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."
OriginalPostID-259999
Discussion posts and replies are publicly visible
0
aloks0189
Certified Lead Developer
over 7 years ago
@kevin may I know the type of both the column which you are trying to multiply. Also try using sum(column1*column2) as column3 while working with Oracle database
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
aloks0189
Certified Lead Developer
over 7 years ago
Make sure column1 as well as column2 should be of type Number(_) or Number(_,_) for decimal
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
kevinn397
over 7 years ago
They are both integer types.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
aloks0189
Certified Lead Developer
over 7 years ago
Try using sum(col1*col2)
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
kevinn397
over 7 years ago
It's giving the same error.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
aloks0189
Certified Lead Developer
over 7 years ago
Can you share the error code starts with ORA-
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
kevinn397
over 7 years ago
There isn't an error code. It's just a message from a pop up that displays, "You cannot perform a * query."
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Tim
Certified Lead Developer
over 7 years ago
Take the spaces out, so you have (column1*column2)
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Karthik
over 7 years ago
I worked for me, i just tried select col1*cal2 from table1. May the SQL client that you are using is not liking the *. Can you share the screenshot of the error?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
kevinn397
over 7 years ago
I attached a copy of the SQL query that I am using for the Query Database Smart Service. As far as I know, I'm required to use double quotes for table names and columns. I removed the spaces and it still gives me the error, "You cannot perform a * query."
The version of Appian I'm using is 7.11, I don't know if that really matters.
PMT_RiskViewQueryMod.txt
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
>