Access SQL Compatibility with Oracle

[RichardF]

Hi,

The system we are developing is intending for intial using with standard Microsoft Access databases. However for future versions we plan to move over to oracle (v 9 or 10). Ideally we would like to achieve compatability whilst we are still in development.

My Question is are the following item standard in sql across both platforms ?

- Table Names or Column Names with Spaces in them
- select * from

- (note the Square brackets).


Thanks in advance.
Rich.

 

[PHV]

As a safety measure, avoid any space or special character in any object name, then you don't need the square brackets in query ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[lespaul]

Don't use ANY look-up fields in the tables:

The Evils of Lookup Fields in Tables

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

 

[cmmrfrds]

Do NOT use spaces in any object or field name. An underscore within a name is okay as long as it doesn't start the name. Sticking with a mixture of upper and lower case usually is the most common.

example:
Table name.
YourTable
Your_Table

Column name.
firstName
lastName
last_Name
first_Name