October 2002
Beginner
864 pages
18h 41m
English
| 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 ... |
Read now
Unlock full access