RE: SQL Pocket Guide

You can get a PDF version of the old Oracle 7 guide at this address:

http://www.unbeta.com/sql_language_quick_ref.pdf

--Michael

-----Original Message-----
Sent: Thursday, June 28, 2001 11:19 AM
To: Multiple recipients of list ORACLE-L

Well, when I forget the correct syntax for creating a reverse index or one of the favorite list topics (LMT), that won't help me too much. I'm looking more for the admin type commands.

I got one from oracle for 7.3 (actually about twice the size of a pocket guide page), but that does not really cut it for 8i....at least for any new stuff. Great for stuff that's been around for awhile. It's also great because it lists most of the privileges with a quick description, as well as quite a few V$, DBA_/USER_/ALL_ tables and descriptions. And quite a few SQL functions. All in 72 fun pages.

As far as your SQL*Plus pocket guide....you are welcome for my contribution to your royalty payment. ;-) I will admit I did order it hoping it would have the SQL command structures as well.

Perhaps you could post your findings to the list. Just not sure if there is a problem with copyright on this. But if you found it on the web, it must be okay =)

Jon Baker
Database Engineer (1/5)
<jcb_at_netsec.net>
www.netsec.net

Jonathan Gennick wrote:
>
> I'd like to follow up on this, because I wrote the SQL*Plus Pocket
> Ref, and I'm planning to revise it soon. One of the things I want to
> do when I revise the book is to add material about the more commonly
> used SQL statements, because, frankly, I'm convinced that's what
> readers really want.
>
> One issue I quickly encounter whenever I think of a SQL Pocket
> Ref is that the syntax for the many, often complex, SQL statements
> just won't fit into a less than 100 page pocket ref format. My current
> thinking is to revise my pocket reference to de-emphasize SQL*Plus
> commands in favor of adding coverage of developer-oriented SQL
> statements such as the following:
>
> INSERT
> UPDATE
> DELETE
> SELECT
> COMMIT
> ROLLBACK
> SET TRANSACTION
> SAVEPOINT
>
> I'm really interested in some feedback on this. Is this a logical
> subset of SQL statements to include in such a book? Is my
> documentation of SQL*Plus commands (describe, copy, the various set
> commands) all that useful? What other commands should I add to the list?
> Regardless of the page-count issue, do you still want all the SQL
> commands in one small book?
>
> Best regards,
>
> Jonathan Gennick

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: jon baker
  INET: jcb_at_netsec.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jenkins, Michael
  INET: Michael.Jenkins_at_Nextel.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).