DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: SQL STANDARDS!

  1. #1
    Join Date
    Mar 2001
    Location
    Reading, U.K
    Posts
    598

    Angry

    Hi all,

    We are building a OLAP product. The product should support oracle, DB2,MYSQL and SQL Server. The product will issue simple SQL queries to the database which is comman for all databases. Is there any standards in SQL which supports all these databases. Plzz forward me to any link which has sql standards and documents.

    Regards,

    Sam
    Cheers!
    OraKid.

  2. #2
    Join Date
    Dec 2001
    Location
    Brazil
    Posts
    282

    for example, Oracle 9i supports right outer join (sql ansi) and (+) [oracle standard] in query statements, both of them. So, I believe if you write your sql code using the most ANSI possible probably there will be compatibility with other rdbms, at least with oracle 9i you may try it.

    I hope I have helped

    F.

  3. #3
    Join Date
    Dec 2001
    Location
    Brazil
    Posts
    282

    this website will help you better:

    http://download-east.oracle.com/otnd...d_sql.htm#4963

Posting Permissions

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


Click Here to Expand Forum to Full Width