-
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.
-
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.
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|