Q&A
| Q1: | Is it true that all implementations have extensions to SQL and, if so, wouldn't this make SQL more difficult? |
| A1: | Most implementations, if not all, have their own extensions or enhancements to ANSI SQL. For example, Oracle has PL/SQL (see Bonus Day 4, “An Introduction to Oracle PL/SQL”) and SQL*Plus (see Bonus Day 3, “Using Oracle SQL*Plus to Satisfy Reporting Needs”); another is Microsoft's Transact-SQL (see Bonus Day 5, “An Introduction to Transact-SQL”). The major implementations are ANSI compliant. Once you learn ANSI SQL, you should be able to easily migrate from one implementation to another. |
| Q2: | What sort of conventions/styles should I think about using? |
| A2: | There is not one convention written in stone that you should use when designing ... |
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.
