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)
<[EMAIL PROTECTED]>
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).