I am trying to transfer an application from MSAccess into Oracle 10g. I the
free version of Oracle 10g Express running locally for development purposes
before uploading to the test server. I have used older versions of Oracle, but
never 10g. It has been a while, but I do not ever remember having to put
everything in quotes before. However, the only way I can get table creates and
record inserts to work is by putting everything in quotes including the table
name. When I look at examples of other Oracle SQL on the Internet, I'm not
seeing this format. Is what I am experiencing correct or is there some setting
I don't know about? Thanks in advance for any advice. This is the query I
have gotten to work.
<cfquery name="tableCreate" datasource="#session.systemTables#">
CREATE table "systemRoles" (
"roleID" NUMBER,
"description" VARCHAR2(50),
"viewable" NUMBER,
"help" VARCHAR2(256),
"createdDate" DATE,
"createdBy" NUMBER,
"modifiedDate" DATE,
"modifiedBy" NUMBER,
constraint "systemRoles_PK" primary key ("roleID")
)
</cfquery>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs
http://www.adobe.com/products/coldfusion/flex2/
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272005
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
