Mastering Oracle SQL and SQL*Plus
This is not a book about advanced SQL. It is not a book about the Oracle optimizer and diagnostic tools. And it is not a book about relational calculus, predicate logic, or set theory. This book is a SQL primer. It is meant to help you learn Oracle SQL by yourself. It is ideal for self-study, but...
Đã lưu trong:
| Tác giả chính: | |
|---|---|
| Định dạng: | Sách |
| Ngôn ngữ: | English |
| Được phát hành: |
Apress
2012
|
| Những chủ đề: | |
| Truy cập trực tuyến: | http://scholar.dlu.edu.vn/thuvienso/handle/DLU123456789/31520 |
| Các nhãn: |
Thêm thẻ
Không có thẻ, Là người đầu tiên thẻ bản ghi này!
|
| Thư viện lưu trữ: | Thư viện Trường Đại học Đà Lạt |
|---|
| Tóm tắt: | This is not a book about advanced SQL. It is not a book about the Oracle optimizer and diagnostic
tools. And it is not a book about relational calculus, predicate logic, or set theory. This book is
a SQL primer. It is meant to help you learn Oracle SQL by yourself. It is ideal for self-study, but it
can also be used as a guide for SQL workshops and instructor-led classroom training.
This is a practical book; therefore, you need access to an Oracle environment for handson
exercises. All the software that you need to install Oracle Database 10g on Microsoft
Windows and to create an Oracle database is available from the CD-ROM included with this
book. This book is based on the following Oracle release:
• Oracle Database 10g for Windows (or Red Hat Linux) Release 10.1.0.x
Although this book assumes an Oracle Database 10g environment, you can also use it
with Oracle9i or even with Oracle8i. However, Oracle is adding new SQL syntax with every
new release; therefore, some SQL syntax examples could fail when issued against these earlier
releases. You can check this yourself by querying the online Oracle documentation. Oracle
SQL Reference offers a section titled “Oracle Database 10g New Features in the SQL Reference”
at the end of the introduction, preceding Chapter 1.
I follow the ANSI/ISO standard (SQL:2003) as much as possible. Only in cases of useful
Oracle-specific SQL extensions do I deviate from this international standard. Therefore, most
SQL examples given in this book are probably also valid for other database management system
(DBMS) implementations supporting the SQL language. By the way, Oracle SQL Reference
contains an Appendix B, “Oracle and Standard SQL,” discussing the differences between the
ANSI/ISO SQL standard and the Oracle SQL implementation. |
|---|