Column Names and Quotes in Oracle. I have an existing table with all column nam

venkats533 over 10 years ago

Column Names and Quotes in Oracle. I have an existing table with all column names in CAPITAL LETTERS. In my XSD, I gave UPPER CASE letters for column name. But Verify is failing when I am trying to add this entity into a data store. Appian is converting all column names to lower case and adding a quotes around them in DDL scripts. How to resolve this issue in Appian. In other words, how do I make Appian not to use quotes around column name or use the exact name in XSD ?...

Discussion posts and replies are publicly visible

Parents

0 venkats533 over 10 years ago

and the DDL generated is
/*
Data Store: EXPRESS_NET_USERS
Created: 2013-12-13T19:34:29.846Z
By: venkat.sakruti
Appian Version: 6.2.0.0
Target Database: Oracle Oracle Database 11g Release 11.1.0.0.0 - Production
Database Driver: Oracle JDBC driver 10.2.0.2.0
*/

/* UPDATE DDL */
create table "users" (
"id" varchar(40) not null,
"first_name" varchar(40),
"last_name" varchar(40),
primary key ("id")
);

/* DROP AND CREATE DDL */
/* WARNING: The DDL commented out below will drop and re-create all tables.
drop table "users" cascade constraints;

create table "users" (
"id" varchar(40) not null,
"first_name" varchar(40),
"last_name" varchar(40),
primary key ("id")
);
*/
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 venkats533 over 10 years ago

and the DDL generated is
/*
Data Store: EXPRESS_NET_USERS
Created: 2013-12-13T19:34:29.846Z
By: venkat.sakruti
Appian Version: 6.2.0.0
Target Database: Oracle Oracle Database 11g Release 11.1.0.0.0 - Production
Database Driver: Oracle JDBC driver 10.2.0.2.0
*/

/* UPDATE DDL */
create table "users" (
"id" varchar(40) not null,
"first_name" varchar(40),
"last_name" varchar(40),
primary key ("id")
);

/* DROP AND CREATE DDL */
/* WARNING: The DDL commented out below will drop and re-create all tables.
drop table "users" cascade constraints;

create table "users" (
"id" varchar(40) not null,
"first_name" varchar(40),
"last_name" varchar(40),
primary key ("id")
);
*/
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data