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

All the Perl that's Practical to Extract and Report

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
More | Login | Reply
Loading... please wait.
  • by djberg96 (2603) on 2005.08.29 20:18 (#42959) Journal
    Creating a grammar for ANSI SQL is possible I suppose, but vendor nuances would make it difficult to come up with an all encompassing solution.

    I wonder if the major DB vendors have their respective grammars hidden in a vault somewhere, taunting us.

    • In Oracle's case, they absolutely do.

      I used to use the online docs with the "rail road" graphics in them (which are derived from the BNF) all the time.
    • That's why SQL::Parser allows you to name the SQL dialect you're working with.

      As a general purpose solution, though, I've thought it would be nice to use the parser from SQLite. A tempting thought, but my C is probably not up to snuff.

      • Is there an Oracle dialect available somewhere for SQL::Parser? I have a little "project" to see which Oracle columns and tables are being used in an internally developed report generator.
        • I'm not an expert with SQL::Parser. You'll have to ask jzed, the author. His contact info is in the docs. He's quite helpful.