Stories
Slash Boxes
Comments

NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.

use Perl

All the Perl that's Practical to Extract and Report

Bad JOINs, what you gonna do More | Login | Reply

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.

Without JavaScript enabled, you might want to use the classic discussion system instead. If you login, you can remember this preference.

easier to learn SQL this way? (Score:1)

by amackey (4963) on 2004.03.23 9:26 (#29567)

This is actually how I teach SQL, insisting on the explicit syntax for clarity (and sometimes correctness, as you point out in your example). See sql_tutorial.pdf [virginia.edu] for the material I use. I absolutely forbid the use of commas as join operators.
Unfortunately, Oracle has no support for standard SQL, using it's own odd syntax for joins (comma-separated tables, and where clauses with optional "+" symbols to denote outer join directions). Ugly.

Reply to This
- Re:easier to learn SQL this way? (Score:1)
  
  by amackey (4963)
  
  Hmm, actually it looks like Oracle 9i has SQL92 support, so nevermind that.

Get More Comments

Stories, comments, journals, and other submissions on use Perl; are Copyright 1998-2006, their respective owners.