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
5 replies
Subscribers
8 subscribers
Views
1772 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
We are using oracle 11g as our database. When I try to use the query database sm
padmanabhanv
over 10 years ago
We are using oracle 11g as our database. When I try to use the query database smart service with the following SELECT query, Select name, address from employee , it does not save and gives a validation error -"Table or view does not exist". However if I change the query to Select "name","address" from "employee", it works fine without issues. I did not see anything in the documentation pertaining to this. Is this how we should be writing the queries?...
OriginalPostID-97107
OriginalPostID-97107
Discussion posts and replies are publicly visible
Parents
0
Patty Isecke
Appian Employee
over 10 years ago
I believe it would be easier if you allowed Appian to create your database structure and include the quotations when creating your queries. However, you do have the option to modify the DDL script.
"When the data structures in your database do not match, you are given the option to create tables manually with a link to download the SQL needed to generate the necessary structure."
forum.appian.com/.../Data_Stores
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
Patty Isecke
Appian Employee
over 10 years ago
I believe it would be easier if you allowed Appian to create your database structure and include the quotations when creating your queries. However, you do have the option to modify the DDL script.
"When the data structures in your database do not match, you are given the option to create tables manually with a link to download the SQL needed to generate the necessary structure."
forum.appian.com/.../Data_Stores
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data