Re: Pocket Guide
Was this an upgrade from a previous version? Or new install?
What script did you run to get the SQL command help. I know where the
one for SQL*Plus resides, but it does not contain SQL help.
Jon
---
Mohammad Rafiq wrote:
Hi Jonathan,
We still have HELP facility with 8.1.6.2. See below please...
Regards
Rafiq
Connected to:
Oracle8i Enterprise Edition Release 8.1.6.2.0 - Production
With the Partitioning option
JServer Release 8.1.6.2.0 - Production
SQL help create table
CREATE TABLE command
PURPOSE:
To create a table, the basic structure to hold user data, specifying
this information:
* column definitions
* integrity constraints
* the table's tablespace
* storage characteristics
* an optional cluster
* data from an arbitrary query
SYNTAX:
CREATE TABLE [schema.]table
( { column datatype [DEFAULT expr] [column_constraint] ...
| table_constraint}
[, { column datatype [DEFAULT expr] [column_constraint] ...
| table_constraint} ]...)
[ [PCTFREE integer] [PCTUSED integer]
[INITRANS integer] [MAXTRANS integer]
[TABLESPACE tablespace]
[STORAGE storage_clause]
[ RECOVERABLE | UNRECOVERABLE ]
[ PARALLEL ( [ DEGREE { integer | DEFAULT } ]
[ INSTANCES { integer | DEFAULT } ]
)
| NOPARALLEL ]
[ CACHE | NOCACHE ]
| [CLUSTER cluster (column [, column]...)] ]
[ ENABLE enable_clause
| DISABLE disable_clause ] ...
[AS subquery]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Thu, 28 Jun 2001 15:45:59 -0800
Thursday, June 28, 2001, 4:15:56 PM, you wrote:
jb help works for sqlplus, if you installed, but if there is a script for
jb building sql command structure, please pass that on. At least 'help
jb index' is only showing the sqlplus commands.
When 8i was released, the SQL statements were removed from the help.
Best regards,
Jonathan Gennick
mailto:[EMAIL PROTECTED] * 906.387.1698
http://Gennick.com * http://MichiganWaterfalls.com * http://MetalDrums.org
--
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).
RE: Pocket Guide
Jon,
just fooling around, I came up with this. run it thru sqlplus.
obviously, change the table reference to your table.
set serveroutput on
spool results.xls
DECLARE
l_date DATE;
start_date DATE := to_date('s_date','mm/dd/');
end_Date DATE := to_date('e_Date','mm/dd/');
loc_sum number;
BEGIN
l_date := start_date;
LOOP
SELECT SUM(col1)
INTO loc_sum
FROM TOM3
WHERE crdate = l_date;
dbms_output.put_line(TO_CHAR(l_date,'mm/dd/') || CHR(9) ||
nvl(loc_sum,0));
l_date := l_date + 1;
EXIT WHEN l_date end_date;
END LOOP;
END;
/
hope this helps
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Friday, June 29, 2001 2:26 PM
To: Multiple recipients of list ORACLE-L
Was this an upgrade from a previous version? Or new install?
What script did you run to get the SQL command help. I know where the
one for SQL*Plus resides, but it does not contain SQL help.
Jon
---
Mohammad Rafiq wrote:
Hi Jonathan,
We still have HELP facility with 8.1.6.2. See below please...
Regards
Rafiq
Connected to:
Oracle8i Enterprise Edition Release 8.1.6.2.0 - Production
With the Partitioning option
JServer Release 8.1.6.2.0 - Production
SQL help create table
CREATE TABLE command
PURPOSE:
To create a table, the basic structure to hold user data, specifying
this information:
* column definitions
* integrity constraints
* the table's tablespace
* storage characteristics
* an optional cluster
* data from an arbitrary query
SYNTAX:
CREATE TABLE [schema.]table
( { column datatype [DEFAULT expr] [column_constraint] ...
| table_constraint}
[, { column datatype [DEFAULT expr] [column_constraint] ...
| table_constraint} ]...)
[ [PCTFREE integer] [PCTUSED integer]
[INITRANS integer] [MAXTRANS integer]
[TABLESPACE tablespace]
[STORAGE storage_clause]
[ RECOVERABLE | UNRECOVERABLE ]
[ PARALLEL ( [ DEGREE { integer | DEFAULT } ]
[ INSTANCES { integer | DEFAULT } ]
)
| NOPARALLEL ]
[ CACHE | NOCACHE ]
| [CLUSTER cluster (column [, column]...)] ]
[ ENABLE enable_clause
| DISABLE disable_clause ] ...
[AS subquery]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Thu, 28 Jun 2001 15:45:59 -0800
Thursday, June 28, 2001, 4:15:56 PM, you wrote:
jb help works for sqlplus, if you installed, but if there is a script for
jb building sql command structure, please pass that on. At least 'help
jb index' is only showing the sqlplus commands.
When 8i was released, the SQL statements were removed from the help.
Best regards,
Jonathan Gennick
mailto:[EMAIL PROTECTED] * 906.387.1698
http://Gennick.com * http://MichiganWaterfalls.com * http://MetalDrums.org
--
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: Mercadante, Thomas F
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).
Re: Pocket Guide
upgrade from 7.3.4.5 platform HP_UX. I think it was already installed in
7.3.4.5Right now I am not my system to check and let you know about
location in 8i...
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Fri, 29 Jun 2001 10:25:33 -0800
Was this an upgrade from a previous version? Or new install?
What script did you run to get the SQL command help. I know where the
one for SQL*Plus resides, but it does not contain SQL help.
Jon
---
Mohammad Rafiq wrote:
Hi Jonathan,
We still have HELP facility with 8.1.6.2. See below please...
Regards
Rafiq
Connected to:
Oracle8i Enterprise Edition Release 8.1.6.2.0 - Production
With the Partitioning option
JServer Release 8.1.6.2.0 - Production
SQL help create table
CREATE TABLE command
PURPOSE:
To create a table, the basic structure to hold user data, specifying
this information:
* column definitions
* integrity constraints
* the table's tablespace
* storage characteristics
* an optional cluster
* data from an arbitrary query
SYNTAX:
CREATE TABLE [schema.]table
( { column datatype [DEFAULT expr] [column_constraint] ...
| table_constraint}
[, { column datatype [DEFAULT expr] [column_constraint] ...
| table_constraint} ]...)
[ [PCTFREE integer] [PCTUSED integer]
[INITRANS integer] [MAXTRANS integer]
[TABLESPACE tablespace]
[STORAGE storage_clause]
[ RECOVERABLE | UNRECOVERABLE ]
[ PARALLEL ( [ DEGREE { integer | DEFAULT } ]
[ INSTANCES { integer | DEFAULT } ]
)
| NOPARALLEL ]
[ CACHE | NOCACHE ]
| [CLUSTER cluster (column [, column]...)] ]
[ ENABLE enable_clause
| DISABLE disable_clause ] ...
[AS subquery]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Thu, 28 Jun 2001 15:45:59 -0800
Thursday, June 28, 2001, 4:15:56 PM, you wrote:
jb help works for sqlplus, if you installed, but if there is a script
for
jb building sql command structure, please pass that on. At least 'help
jb index' is only showing the sqlplus commands.
When 8i was released, the SQL statements were removed from the help.
Best regards,
Jonathan Gennick
mailto:[EMAIL PROTECTED] * 906.387.1698
http://Gennick.com * http://MichiganWaterfalls.com *
http://MetalDrums.org
--
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).
_
Get your FREE download of MSN Explorer at http://explorer.msn.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mohammad Rafiq
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).
Re: Pocket Guide
Hi Oracle used to ship A SQL Language Quick reference with the paper doc's in Oracle 7 days. This had 72 pages (than) and also contained a one liner about the dba, v$ views. Furthermore it had the syntax for sql statements and function descriptions. They no longer make these but my copy is well used and slowly falling apart (not no mention out of date). Jack Jonathan Gennick To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] jonathan@genn cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) ick.com Subject: Re: Pocket Guide Sent by: [EMAIL PROTECTED] om 28-06-2001 02:00 Please respond to ORACLE-L 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 mailto:[EMAIL PROTECTED] * 906.387.1698 http://Gennick.com * http://MichiganWaterfalls.com * http://MetalDrums.org Wednesday, June 27, 2001, 6:50:09 PM, you wrote: jb Has anyone run across a Pocket Guide for SQL. I don't need one for jb SQL*Plus or PL/SQL. Just sometimes I cannot remember complete syntax jb for some commands and a quick guide really helps. Sucks getting old. jb I don't see one from O'Reilly which normally handles a series like this. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Gennick 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). = De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een
Re: Pocket Guide
Jon, Kishore Bhamidipati has written a paper back book 337 pages that covers the Complete Set of SQL Commands for Oracle, Informix, and Sybase Systems plus special coverage of Oracle's latest PL/SQL and SQLJ extensions. I know it is not a pocket reference but it is small enough and light enough to carry in your linch bag. Osborne Press ISBN 0-07-882460-5 ROR mª¿ªm [EMAIL PROTECTED] 06/27/01 06:50PM Has anyone run across a Pocket Guide for SQL. I don't need one for SQL*Plus or PL/SQL. Just sometimes I cannot remember complete syntax for some commands and a quick guide really helps. Sucks getting old. I don't see one from O'Reilly which normally handles a series like this. -- Jon Baker Database Engineer (1/5) [EMAIL PROTECTED] www.netsec.net NETSEC 13525 Dulles Technology Drive Herndon, VA 20171 703.561.0420 x265 - phone 703.561.0426 - fax This electronic message contains information from NETSEC or its affiliates, which may be confidential, proprietary or otherwise protected from disclosure. The information is intended to be used solely by the recipient(s) named above for the purposes intended by the originator. If you are not an intended recipient, be aware that any review, disclosure, copying, distribution or use of this transmission or its contents is prohibited. If you have received this transmission in error, please notify us immediately by telephone at (703) 561-0420, or by electronic mail at [EMAIL PROTECTED] -- 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: Ron Rogers 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).
RE: Pocket Guide
I know it is not a pocket reference but it is small enough and light enough to carry in your linch bag. Do you carry this Linch Bag around to lynch developers? :) Then slap them round the head with the book - This is the way to DO IT!! LOL, sorry couldn't resist! -Original Message- Sent: Thursday, June 28, 2001 02:06 To: Multiple recipients of list ORACLE-L Jon, Kishore Bhamidipati has written a paper back book 337 pages that covers the Complete Set of SQL Commands for Oracle, Informix, and Sybase Systems plus special coverage of Oracle's latest PL/SQL and SQLJ extensions. I know it is not a pocket reference but it is small enough and light enough to carry in your linch bag. Osborne Press ISBN 0-07-882460-5 ROR mª¿ªm [EMAIL PROTECTED] 06/27/01 06:50PM Has anyone run across a Pocket Guide for SQL. I don't need one for SQL*Plus or PL/SQL. Just sometimes I cannot remember complete syntax for some commands and a quick guide really helps. Sucks getting old. I don't see one from O'Reilly which normally handles a series like this. -- Jon Baker Database Engineer (1/5) [EMAIL PROTECTED] www.netsec.net NETSEC 13525 Dulles Technology Drive Herndon, VA 20171 703.561.0420 x265 - phone 703.561.0426 - fax This electronic message contains information from NETSEC or its affiliates, which may be confidential, proprietary or otherwise protected from disclosure. The information is intended to be used solely by the recipient(s) named above for the purposes intended by the originator. If you are not an intended recipient, be aware that any review, disclosure, copying, distribution or use of this transmission or its contents is prohibited. If you have received this transmission in error, please notify us immediately by telephone at (703) 561-0420, or by electronic mail at [EMAIL PROTECTED] -- 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: Ron Rogers 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: Mark Leith 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).
RE: Pocket Guide
Okay so I'm knot a typist. In order to get the developers to do what is proper and productive you have to start with their boss or higher. After all they are just following policies defined from above. ROR mª¿ªm [EMAIL PROTECTED] 06/28/01 11:11AM I know it is not a pocket reference but it is small enough and light enough to carry in your linch bag. Do you carry this Linch Bag around to lynch developers? :) Then slap them round the head with the book - This is the way to DO IT!! LOL, sorry couldn't resist! -Original Message- Sent: Thursday, June 28, 2001 02:06 To: Multiple recipients of list ORACLE-L Jon, Kishore Bhamidipati has written a paper back book 337 pages that covers the Complete Set of SQL Commands for Oracle, Informix, and Sybase Systems plus special coverage of Oracle's latest PL/SQL and SQLJ extensions. I know it is not a pocket reference but it is small enough and light enough to carry in your linch bag. Osborne Press ISBN 0-07-882460-5 ROR mª¿ªm [EMAIL PROTECTED] 06/27/01 06:50PM Has anyone run across a Pocket Guide for SQL. I don't need one for SQL*Plus or PL/SQL. Just sometimes I cannot remember complete syntax for some commands and a quick guide really helps. Sucks getting old. I don't see one from O'Reilly which normally handles a series like this. -- Jon Baker Database Engineer (1/5) [EMAIL PROTECTED] www.netsec.net NETSEC 13525 Dulles Technology Drive Herndon, VA 20171 703.561.0420 x265 - phone 703.561.0426 - fax This electronic message contains information from NETSEC or its affiliates, which may be confidential, proprietary or otherwise protected from disclosure. The information is intended to be used solely by the recipient(s) named above for the purposes intended by the originator. If you are not an intended recipient, be aware that any review, disclosure, copying, distribution or use of this transmission or its contents is prohibited. If you have received this transmission in error, please notify us immediately by telephone at (703) 561-0420, or by electronic mail at [EMAIL PROTECTED] -- 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: Ron Rogers 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: Mark Leith 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: Ron Rogers 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).
Re: Pocket Guide
I'm more interested in the SQLPlus commands. Especially the various SET options. They are not intuitive (to me) and, since I only use them in SQLPlus they are not fresh in my memory. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).
RE: Pocket Guide
If you have SQL*Plus help installed you can try this: SQL spool set_help.txt SQL help set SQL spool off SQL edit set_help.txt Also try SQL help commands -Original Message- Sent: Thursday, June 28, 2001 12:43 PM To: Multiple recipients of list ORACLE-L I'm more interested in the SQLPlus commands. Especially the various SET options. They are not intuitive (to me) and, since I only use them in SQLPlus they are not fresh in my memory. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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). * * * * * Freedom of Information Act Notice * * * * * The information in this email is subject to the record protection mandated by 5 United States Code 552(b)(4) and relevant judicial opinions. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Edward 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).
Re: Pocket Guide
Quick way to check sytax ,type on sqlpromt help create table show all and you will see what you want..provided you have installed help on your database Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thu, 28 Jun 2001 08:42:34 -0800 I'm more interested in the SQLPlus commands. Especially the various SET options. They are not intuitive (to me) and, since I only use them in SQLPlus they are not fresh in my memory. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq 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).
Re: Pocket Guide
help works for sqlplus, if you installed, but if there is a script for building sql command structure, please pass that on. At least 'help index' is only showing the sqlplus commands. Jon Baker Database Engineer (1/5) [EMAIL PROTECTED] www.netsec.net Mohammad Rafiq wrote: Quick way to check sytax ,type on sqlpromt help create table show all and you will see what you want..provided you have installed help on your database Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thu, 28 Jun 2001 08:42:34 -0800 I'm more interested in the SQLPlus commands. Especially the various SET options. They are not intuitive (to me) and, since I only use them in SQLPlus they are not fresh in my memory. -- 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).
Re: Pocket Guide
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 mailto:[EMAIL PROTECTED] * 906.387.1698 http://Gennick.com * http://MichiganWaterfalls.com * http://MetalDrums.org Wednesday, June 27, 2001, 6:50:09 PM, you wrote: jb Has anyone run across a Pocket Guide for SQL. I don't need one for jb SQL*Plus or PL/SQL. Just sometimes I cannot remember complete syntax jb for some commands and a quick guide really helps. Sucks getting old. jb I don't see one from O'Reilly which normally handles a series like this. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Gennick 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).
