Q&A

Q1:What is the difference between the ODBC API and the Oracle and Sybase APIs?
A1: On a function-by-function level, Oracle and Sybase are remarkably similar, which is not a coincidence. Multiple corporate merges and divorces have led to libraries that were derived from somewhat of a common base. ODBC's API is more generic. (It isn't specific to any database.) If you need to do something specific to a database or tune the performance of a specific database, you might consider using that database's API library in your code.
Q2:With all the available products, how do I know what to use?
A2: In a business environment, product selection is usually a compromise between management and “techies.” Management looks at the cost of a product; techies ...

Get Sams Teach Yourself SQL in 21 Days, Fourth Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.