SQL - Oracle Vs. Access

Results 1 to 3 of 3

Thread: SQL - Oracle Vs. Access

  1. #1
    Join Date
    Dec 1969

    Default SQL - Oracle Vs. Access

    Is there really any difference with the SQL INSERT INTO and SELECT FROM commands in Oracle, Access, and SQL Server. Correct me if I am wrong, but for most WEB apps those are the SQL commands that would be used. Most data issues like verification, and data integrity can be done using VBScript before reading or writing to the database(?). If there are differences, let me know. I am thinking it would be very easy to switch databases by just using a different DSN and not have to re-code anything. the way I think things could be done is to use the INPUT and SELECT statements to make contact with the database, but use VBScript of manipulation of the data, rather than using SQL.

  2. #2
    Join Date
    Dec 1969

    Default RE: SQL - Oracle Vs. Access

    The only differences I have found is how they handle dates and formatting strings.<BR><BR>I would recommend the book SQL Unleashed (by SAMS). It goes into great detail, and even shows some differences between ORACLE and SQL Server.<BR><BR>HTH<BR><BR>Jerry

  3. #3
    Adam Werner Guest

    Default RE: SQL - Oracle Vs. Access

    To interchange your databases, you will have to rewrite some of your more complex SQL statements.<BR><BR>A simple SELECT statement will probably not have to be rewritten.<BR><BR>The really big things that I&#039ve found that will require any sort of rewriting of SQL will be:<BR> 1) insertion/update of specially formatted data types (ie. dates)<BR> 2) joins between table<BR><BR>If you wanted to write a truly &#039blind&#039 piece of code, you might be better using some of the different ADO methods for inserting, updating, and deleting.<BR><BR>Adam<BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts