We are using oracle 11g as our database. When I try to use the query database sm

padmanabhanv over 11 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?...

Discussion posts and replies are publicly visible

Parents

0 Patty Isecke
Appian Employee
over 11 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 11 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