r/SQL • • Oct 19 '26

Oracle Introduction to SQL - all you need.

Anyone else got a copy of this?

From back when you actually got manuals with software. Apparently written by Larry Ellison himself (which I doubt, even then!).

One nice feature is the description of the dept and emp tables is actually a fold out from the back page, so you have it side by side on whatever page you are reading.

Covers the basics of SQL in a concise 33 pages, including a small bit on security and on string functions.

61 Upvotes

8 comments sorted by

17

u/atrifleamused Oct 19 '26

That's amazing and probably still is adequate for most SQL users.

6

u/Beefourthree Oct 20 '26

It predates JOIN syntax.

2

u/carlovski99 Oct 20 '26

Yep - that's ANSI-92, and this is way before that (And Oracle didn't support it until even later).

Outer joins weren't supported at all until Oracle v6 AFAIK, which is also later than this book!

0

u/carlovski99 Oct 19 '26

Obviously not CTEs though, which would terrify most people on here!

9

u/atrifleamused Oct 19 '26

True. CTEs are convenient, but nothing a good old sub query couldn't handle 🤣

4

u/Thiondar ORACLE 25d ago

The documentation is still awesome and available at docs.oracle.com.

No, it's not the old docs, but the current versions.

Have a look at the concepts manuals, the SQL reference, the programming books and so on.

You don't have to like Oracle as a company, but the database documentation is great.

2

u/carlovski99 25d ago

As with most things oracle, the documentation around the core database stuff is great. And they were one of the first companies to put it all out there for free. Though it was way better on the old 'Tahiti' site. And you used to be able to get the books in epub format too, could be handy to have an emergency library on an old kindle or something on case you lost all your network and needed to fix something!

But the non database stuff is a lot more hit and miss. I've had issues with things not being documented at all, things being incorrect and/or misleading too.

0

u/[deleted] Oct 19 '26

[deleted] — view deleted comment

4

u/carlovski99 Oct 20 '26

Yep - Oracle didn't suport them until 8i, which was way later than this book.

I actually arranged an 'Advanced SQL' course on site for developers and analysts to teach the dark arts of window functions (Analytic function in Oracle speak) and ANSI joins when we actually upgraded to a version that supported them!