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
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 numbe
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:
>
Those heathens
Jonathan Gennick wrote:
>
> 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 comman
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
What about O'Reilly's Oracle SQL: The Essential Ref? It's about 370
pages long, covers SQL syntax and a few other things. Has anyone
looked at that?
Best regards,
Jonathan Gennick
mailto:[EMAIL PROTECTED] * 906.387.1698
http://Gennick.com * http://MichiganWaterfalls.com * http://MetalDrums.or
Dick,
Would you be interested in reviewing an RMAN pocket ref? I'm currently
editing the book, and it should be ready for review in a week or two.
If you'd be interested in reading it over, let me know.
Best regards,
Jonathan Gennick
mailto:[EMAIL PROTECTED] * 906.387.1698
http://Gennick.com
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 remove
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
-
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 -080
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
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 8iat least for any
new stuff.
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
racle'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
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
lus 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 ac
ybase 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 >>>
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 re
athan
Gennick To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
Subject: Re: Pocket Guide
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 o
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 serie
21 matches
Mail list logo