HDTenEightyP/NetNews huggingface dataset:
From: nigelc@cognos.com (Nigel Campbell)
Subject: De Facto Oracle book
Organization: Cognos Incorporated, Ottawa CANADA
Date: Sat, 21 Nov 1992 02:55:57 GMT

Looking for books on Oracle that are considered by most
people as 'The Bible' of Oracle books. Need, the
publisher,author(s),isbn,price and any review comments.
Would be interested in any that try to tackle V7 too
beyond a summary of syntax/functionality which I can
get from the manuals. thanks.


-- 
Nigel Campbell          Voice: (613) 738-1338 ext 3016    P.O. Box 9707
Cognos Incorporated       FAX: (613) 738-0002             3755 Riverside Dr.
Database and Connectivity MCI: nigel campbell || 307-4729 Ottawa, Ontario
UUnet: nigelc@cognos.COM                                  CANADA  K1G 3Z4
From: anthis@bcstec.ca.boeing.com (Mike Anthis)
Newsgroups: comp.databases.oracle
Subject: xsqlforms30 - why are leftmost pixels truncated in each field
Keywords: forms, xwindows, field, truncation
Date: 18 Nov 92 22:39:53 GMT
Organization: Boeing Computer Services, Seattle


Hello, please forgive me if there is a FAQ entry for this.

I am using xsqlforms30 to design forms, on a sun4 system,
using openwin3.0 and oracle version 6.xxxx.  I am redirecting
my display from a server where I run xsqlforms to my SS1 workstation.

I am having trouble with the leftmost character of each field,
and with the thin cursor.  It seems that the box that is drawn
around the field, plus a pixel or two of border around the box's
lines, overwrites the left edge of the first character displayed
in the field.  Also, the cursor is not visible when it is on
the first character, since it is just a thin line that appears
to the left of the character it is on.

This occurs both in the forms designer and in the executing form.

Can I fix this so that the cursor and the first character in
each field are not partially hidden?

Thanks for your help.   Email to me and I will summarize.

mike
-- 
------------------------------------------------------
Mike Anthis          anthis@sleepy.ns.cs.boeing.com
90% of good taste is found in 10% of the population.
------------------------------------------------------
From: holowczk@rwja.umdnj.edu (Richard Holowczak)
Newsgroups: comp.databases.oracle
Subject: How to use time in Oracle
Summary: How to use time in Oracle
Keywords: Oracle time
Date: 15 Nov 92 17:40:34 GMT
Distribution: comp
Organization: Robert Wood Johnson Medical School, Piscataway NJ


How do people use time in Oracle databases?  I am writing a manufacturing
system which needs to know when things start and end and how long they will
take to complete.  I have tried using the TIME component of the DATE
datatype but this very clumsy to work with.  Other options might be to
make several INTEGER fields and use them as HOURS and MINUTES.  This also
has shortcommings.  Any advice out there?


The operations I'd like to be able to do are the following:

	Data entry of the current time of day (10:45 pm) as well as
	the time to complete a task (1 hour and 10 minutes).

	Time math such as Current time is 11:00 and task will take
	1 hour and 30 mins. to complete so task should be done at
	12:30.  Other time math might be: This task will take 30%
	longer to complete.  How long is this in hours and minutes?
	(i.e.  30% of 1 hour and 10 mins. = ?)

	Time comparisons such as A process is "Due" to complete at 
	11:30.  It really completed at 11:35.  Is it late or early and
  	if so by how much?


Thanks in advance

Rich Holowczak
Rutgers University
Industrial Engineering
Newsgroups: comp.databases.oracle
From: aaj@cmutual.com.au (Tony Jambu)
Subject: Re: SNMP/SMP MIB for Oracle from Oracle?
Organization: Colonial Mutual Group 
Date: Tue, 17 Nov 1992 05:39:40 GMT

In article <1992Nov12.022001.6131@indetech.com>, rec@indetech.com () writes:
> 
> I've heard a glimmer of a rumor that Oracle may have made available
> an SNMP or SMP Management Information Base for Oracle databases.
> 
> 1. Is there such a beast?
> 
> 2. What sort of proxy-agent technology does it require?
> 
> 3. Is this a "real" Oracle product, a "consulting" Oracle product,
>    or a "future" Oracle product?
> 
> Yes, I'll call my sales rep as well, but he won't be open till
> 9:00 AM ;-)
> -- 
> --
> ____*_  Rick Cobb		   	rec@indetech.com 
> \  / /  Independence Technologies, Inc {sun,pacbell,uunet}!indetech!rec
>  \  /   42705 Lawrence Place	   	Fax:   (US) 510 438 2034

Yes there is such a beast out there and it is called DDS/Patrol (ie if it
is what you are referring to).   DDS stands for distributed Data Systems The
product is written by a company in Sydney, Australia and Oracle financed
part of the development.  One of the main developers name is Martin
Picard.  Yes, all you Oracle staff out there, Martin Picard was a former
Oracle staff who used to work in the networking area.

Oracle's involvement in it was to help incorporate the Oracle knowledge
into the product.  Basically the product could monitor any DBMS if you
wanted to.  It is GUI and has voice as well (I believe).  I had a chance to
play with it and it is worth having a serious look at. The product is
currently in beta test at some sites in Aust.


I could go on and on about it but I dont have the time.  If you want, you
could contact you Oracle rep and asked for some documentation.  I received
about 15 pages in all.


Oracle will be marketing the product and some ridiculous figures have been
thrown around about the cost of the product.  There are two parts to the
product, the master and client with different prices for each.

-------------------------------------------------------------------------------
 _____       ________ / ____ |Tony Jambu, Database Administrator
  /_  __       /_ __ /       |Colonial Mutual Life Australia. (ACN 004021809)
 /(_)/ ((_/ \_/(///(/_)/_(   |EMAIL:  TJambu@cmutual.com.au
 \_______/                   |PHONE:  +61-3-6076448       FAX:  +61-3-6076198
-- 
 _____       ________ / ____ |Tony Jambu, Database Administrator
  /_  __       /_ __ /       |Colonial Mutual Life Australia. (ACN 004021809)
 /(_)/ ((_/ \_/(///(/_)/_(   |EMAIL:  TJambu@cmutual.com.au
 \_______/                   |PHONE:  +61-3-6076448       FAX:  +61-3-6076198
From: news@teetot.acusd.edu (Allen )
Newsgroups: comp.databases.oracle
Subject: output SQLForms30 query results to printer
Date: 17 Nov 92 01:07:07 GMT
Article-I.D.: teetot.1992Nov17.010707.13339
Distribution: usa
Organization: usd


	Is there anyway to print out more than a page of query results
in SQLForms30, instead of screen dump by pressing ctrl-p. 
Any information regarding this SQLForms30 interfacing to SQLREP is
greatly appreciated.
	Allen Tsai
	University of San Diego
	tsai@teetot.acusd.edu
Newsgroups: comp.databases.oracle
From: smuench@oracle.com (Steven P. Muench)
Subject: Re: PL/SQL Tables in Stored Procs
Organization: Oracle Corp., Belmont CA
Date: Fri, 20 Nov 1992 06:18:16 GMT
X-Disclaimer: This message was written by an unauthenticated user
              at Oracle Corporation.  The opinions expressed are those
              of the user and not necessarily those of Oracle.

In article <1992Nov18.014202.7076@exu.ericsson.se> ebuhob@ebu.ericsson.se (Hans Bergsten 6264) writes:

>   I am trying to use all the new great PL/SQL features in ORACLE7
>   (Developer's Release, V7.0.10.3.1) in an applicationon the SunOS
>   4.1 platform....
>
>   -  In a package, I have to public variables declared like:
>
>	TYPE IntTabType	IS TABLE OF BINARY_INTEGER INDEX BY BINARY_INTEGER;
>	int_tab		IntTabType;
>	int_index		BINARY_INTEGER;
>
>     If I try to initiate these variables from SQL*Plus, I get the following
>      results:
>
>	SQL> begin test.intab(1) := 0; end;
>	  2  /
>	begin test.intab(1) := 0; end;
>	*
>	ERROR at line 1:
>	ORA-06501: PL/SQL: internal error 75946, arguments: [], [], [], []
>
>	SQL> begin test.i := 0; end;
>	  2  /
>
>	PL/SQL procedure successfully completed.


I tested these scenarios in 7.0.11.2 on VMS and they all
create/execute successfully. Thanks for taking the time to test the
new features. Hopefully you're finding them very flexible and useful
overall, even if some glitches come up in the Developers' Release. We
of course depend on curious souls such as yourself to poke at our
software from all different angles and give us feedback like this.

Thanks.

_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
  Steve Muench              Email: smuench@oracle.com 
  SQL*Forms Development
  Product Manager
  Oracle Corporation
From: mmcgreg@uswnvg.com (Mark McGregor)
Newsgroups: comp.databases.oracle
Subject: Re: how to insert datetime in PRO*C
Date: 21 Nov 92 21:41:10 GMT
Organization: U S WEST NewVector Group, Inc.
X-Newsreader: Tin 1.1 PL5


: exec sql execute s1 using :var1,:var2,to_date(....) does not work

Are you sure this does not work?  I use this construct regularly.  I
Handle all dates in the format YYYYMMDDHH24MISS (mostly because the
Oracle date format is functionally useless for anything) and so I
have to use this sort of construct all the time.  However, I do not
usually use the prepare and execute statement.

1) Did you use  to_date( :v3, "mm/dd/yy hh24:mi" )?

2) Did you print out the values to make sure they were correct?


Newsgroups: comp.databases.oracle
From: tretech@well.sf.ca.us (Tretech Solutions Inc)
Subject: ORACLE DBA job in NJ
Organization: Whole Earth 'Lectronic Link
Distribution: usa
Date: Fri, 20 Nov 1992 13:41:19 GMT

Tretech Solutions Inc, is a NJ based consulting firm, servicing the
computing and engineering needs of Fortune 500 companies. We offer 
highly competetive compensation, a full line of benefits, and will sponsor.

Immediate Consulting Positions in Central NJ:

Oracle V7.0 DBA. Additional duties include TCP/IP network tuning.
Excellent compensation.

Qualified candidates only, FAX your resume immediately to 908-946-4175,
and follow up with either Email copy or DOS compatible floppy (with 
paper copy) to Tretech Solutions, Inc., PO Box 44, Holmdel, NJ 07733.

Newsgroups: comp.databases.oracle
From: omikko@cs.joensuu.fi (Olli Mikkonen)
Subject: Re: how to insert datetime in PRO*C
Organization: University of Joensuu
Date: Mon, 23 Nov 1992 08:31:42 GMT

kortikar@mipos2.intel.com (Aniruddha Kortikar) writes:

>varchar var1;
>varchar var2;
>varchar datetime[15];
>datetime.arr contains "mm/dd/yy hh24:mi" i.e "12/30/92 15:54"
>datetime.len contains 14     

>char stmt[1000];
>strcat(stmt,"insert into tablename (f1,f2,date_field) values (:v1,:v2,:v3)");
>exec sql prepare s1 from :stmt
>exec sql execute s1 using :var1,:var2,:datetime

>ORA-01859 : a number was found in a date and a letter was expected.

>How can I force oracle to consider this as datetime. in normal sql I would have
>done 
>insert into tab (f1,f2,date_field) values 
>		(v1,v2,to_date('char text','mm/dd/yy hh24:mi');

>exec sql execute s1 using :var1,:var2,to_date(....) does not work

to_date() is SQL-code.  It is not a host variable.  Therefore it
has to be in the sql-statement to be executed, not in the
host variable list.  Use something like this:

strcat(stmt,"insert into tablename (f1,f2,date_field) ");
strcat(stmt,"values (:v1,:v2,to_date(:v3, 'mm/dd/yy hh24:mi'))");
exec sql prepare s1 from :stmt
exec sql execute s1 using :var1,:var2,:datetime

>Aniruddha Kortikar (kortikar@mipos2.intel.com)
>-------------------------------------------------------------------------------
>E-mail 	: kortikar@mipos2.intel.com | A billion here, a billion there ...
>Phone(W): 408 765 5515              | pretty soon it adds upto real money.
>-------------------------------------------------------------------------------
Olli Mikkonen
-- 
Olli Mikkonen		: Any opinions above are purely my personal ones.
Internet: 		: Especially they do not reflect my employers
omikko@cs.joensuu.fi	: official opinions.
Newsgroups: comp.databases.oracle
From: martinher@urvax.urich.edu
Subject: Current Quality of Oracle Service and Support
Reply-To: martinher@urvax.urich.edu
Organization: University of Richmond
Date: Thu, 19 Nov 1992 03:26:30 GMT

We are investigating Oracle as a solution and are curious.  What current
experiences - good or bad - are you having with Oracle support?  How
is the general quality of the software releases?  Are they shipping many
buggies and how are they at responding to and fixing those that you 
do uncover?
 
If you mail to me directly, I will summarize.  Please state if you want
your signature or return address supressed.  I need the truth even if
you don't want to complain publicly.  I also do want to hear success 
stories.
 
Herb Martin
martinher@urvax.urich.edu
From: epeas@abds7.aberdeen.chevron.com (John Peach)
Newsgroups: comp.databases.oracle
Subject: Re: Way to view locks - who,what,where
Date: 16 Nov 92 12:24:42 GMT
Reply-To: epeas@aberdeen.chevron.com
Organization: Chevron (UK) Ltd.
Bcc: epeas@aberdeen.chevron.com
Disclaimer: The opinions expressed are mine; _not_ those of        
            the company I work for.

In article <X6V7TB1w165w@iowegia.uucp>, bob@iowegia.uucp (Bob Powers) writes:
|> Does anyone have a SQL script available that will display all of the
|> locks, who has them, what they are on, what type they are and who is waiting
|> on them.  THis would be like the lock screen in SQLDBA Monitor but without
|> having to fire monitor up.

No script, but...

look in the back of the DBA manual for the V$ views

V$_LOCK
V$LOCK
V$LATCH
etc.

|> 
|> This would be used when a user calls and is locked up.  I could run this 
|> script and tell them who and what is holding them up
|> 
|>                                                        Bob Powers
|>                                                        bob@ia-ngnet.army.mil

-- 
                               John Peach
                           Chevron (UK) Ltd.
   Ninian House, Crawpeel Road, Altens, Aberdeen, AB1 4LG, Scotland.
   Internet: epeas@aberdeen.chevron.com       Phone: +44 224 242637
Newsgroups: comp.databases.oracle
From: copler@moose.cs.indiana.edu (judith copler)
Subject: WORKSHOP ON CURRENT & FUTURE TRENDS IN DATABASE TECHNOLOGY
Organization: Computer Science, Indiana University
Date: Thu, 19 Nov 1992 14:39:33 EST
X-Mailer: Mail User's Shell (7.2.3 5/22/91)


WORKSHOP TITLE:

CURRENT AND FUTURE TRENDS IN DATABASE TECHNOLOGY

Friday, Dec 4, 1992 

INDIANAPOLIS, INDIANA

Objective:  All participants should gain an understanding of the
trends in database architectures, the trends in both general and
specialized database systems, and how the most popular of these
trends are being incorporated into commercial relational database
systems.

Who Should Attend:  Analysts, database applications programmers,
database designers and administrators, MIS managers, technology
consultants

Instructors:  Ed Robertson and Dirk Van Gucht

Session I -  Introduction:  How Trends Are Born 9:00-9:30
A.  Sources of Change
B.  The Change Time Line
C.  The Politics of Change

Session 2 - Trends in Information System Architecture 9:30-10:30

A.  Client/Server Database Architectures
B.  Distributed Database Architectures
C.  Parallel Database Architectures
D.  Heterogeneous Database Architectures
E.  Example:  A Parallel Distributed Decision Support System

Session 3 - Trends in Database Systems 10:45-12:15

A.  Expert Systems and Deductive Database Systems
B.  Object-Oriented Database Systems
C.  Heterogeneous Database Systems
D.  Extensible Database Systems
E.  Example:  An Expert System

Session 4 - Trends in Specialized Database Systems 1:15-2:15

A.  Text Databases
B.  Temporal Databases
C.  Large Object Database 
D.  Scientific Databases
E.  Example:  A Biomedical Database System

Session 5 - Trends in Commercial RDBMS Products 2:30-4:00

A.  Supporting Client/Server Architectures
B.  Supporting Distributed Architectures
C.  Supporting Constraints
D.  Supporting Object Identity
E.  Supporting Procedures and Triggers
F.  Supporting Various Types of Indexes and File Organizations
G.  Offering More and Better Tools

Session 6 - How Trends are Adopted 4:00-4:30

A.  Gaining a Competitive Advantage
B.  Evaluating Products
C.  Developing In-house Expertise
D.  Selecting a Methodology and Tools which Support It

For registration and other information please contact

Ms. Hallie Rose
812-855-2490
From: mickel@OES.ORST.EDU (Paul M. Mickel)
Newsgroups: comp.databases.oracle
Subject: sqlforms30 questions
Date: 21 Nov 92 04:01:09 GMT
Article-I.D.: talon.1ekca5INNjsq
Distribution: world
Organization: Oregon Extension Service, Oregon State University, Corvallis, Or.
NNTP-Posting-Host: oes.orst.edu

Hello All,


First of, I'd like to thank all the people that responded to the question I
had concerning SQR. The answer that was most useful to us came from 
richards@sequent, who suggested that we place the resulting time field into
another variable to extract the time for the report. After talking to the 
vendor, it seems that this is the only do this.

Second, I have another question I'd like to pose to the group. We are attempt-
ing to write some generic reports that will process input data depending on
which field is queried. We are using SQR to do this, which is fairly simple if
the report can determine what type of data is being passed in.

However, our problem arises between integrating the two parts. Ideally, we'd
like to pass whatever is in the field during the "ENTER-QUERY" mode in
sqlforms30. However, it seems that it won't allow us to touch this field after
this mode has been entered. Another approach we have attempted is
to base the query off any field, and dump the resulting key fields to a
text file, which is then read in by SQR. However, our problem with this is
that the "on-validate" triggers seem to fire for only those records displayed,
even though a user query may return more records than can be displayed in the
block (we are dealing with a multi-record block). While it is possible to
navigate using KEY-DOWN, and add it to the text file, we can't be guaranteed
the reliability of this method. I personally tried a test using the 
"POST-QUERY" trigger to do this, but the results are the same as using
"ON-VALIDATE-FIELD" trigger.

An example would be that I retrieve 11 records in a query, but only the 
first 10 are displayed. The text file then contains the entries for the
first 10 records retrieved, until I navigate to the 11th record
by hand (pressing KEY-DOWN, for instance). After navigation, there are 11
output in the text file, which is sent to SQR. Our goal here is to have it so 
that *all* 11 get inserted into this text file, not just the ones current-
ly displayed, without having to press KEY-DOWN.

So, the questions are:

0. Is this a correct understanding of how validation is done for a block??
1. Are there suggestions to get around this kind of problem??
2. Is changing the validation unit good enough to solve this problem??

We have looked thru our documentation, with little success. This would not be
much of a problem, except that, being a production database, this is a
very common occurance.

As usual, I will summarize to the grp (please forgive the lapse time, as
I stay extremely busy). Thanks in advance.

-pmm

-- 
Paul M. Mickel			  	   Internet:mickel@oes.orst.edu
Sysadmin, Oregon Extension Service	   Corvallis, OR 97331
Database Programmer, Teledyne Wah Chang    Albany, OR 
Disclaimer: Neither employer has *ever* claimed any of my opinions.
From: kortikar@mipos2.intel.com (Aniruddha Kortikar)
Newsgroups: comp.databases.oracle
Subject: Re: how to insert datetime in PRO*C
Date: 23 Nov 92 23:07:58 GMT
Organization: Intel Corporation, Santa Clara, CA USA

One has to use 
insert into .... values :v1,:v2,todate(:v3,'mm/dd/yy hh24:mi') while preparing
the sql statement. and NOT while executing the statement as in 

exec sql execute :stmt using ....,to_date(....)

Aniruddha Kortikar(kortikar@mipos2.intel.com)
-------------------------------------------------------------------------------
E-mail 	: kortikar@mipos2.intel.com | A billion here, a billion there ...
Phone(W): 408 765 5515              | pretty soon it adds upto real money.
-------------------------------------------------------------------------------
Newsgroups: comp.databases.oracle
From: rmorley@mis.mi04.zds.com (Ron Morley)
Subject: SQL Server vs. Oracle
Keywords: Oracle, SQL Server
Organization: Zenith Data Systems
Distribution: usa
Date: Tue, 17 Nov 1992 18:49:47 GMT

I need to find articles comparing Oracle and Microsoft's SQL Server.  I
particularly need information regarding the speed and robustness of these
products.  Oracle should be running on a UNIX machine if possible.  Please
send me responses via e-mail.  I will post the results of this search later
if anyone else wants them.

Thanks in advance,
Ron Morley
Zenith Data Systems
Hilltop Rd. 
St. Joseph, MI.

e-mail: R.Morley@mis.mi04.zds.com
From: ebuhob@ebu.ericsson.se (Hans Bergsten 6264)
Newsgroups: comp.databases.oracle
Subject: PL/SQL Tables in Stored Procs
Date: 18 Nov 92 01:42:02 GMT
Reply-To: ebuhob@ebu.ericsson.se
Organization: Ericsson Business Communications, Inc.
X-Disclaimer: This article was posted by a user at Ericsson.
              Any opinions expressed are strictly those of the
              user and not necessarily those of Ericsson.

I am trying to use all the new great PL/SQL features in ORACLE7 (Developer's 
Release, V7.0.10.3.1) in an applicationon the SunOS 4.1 platform. As long as I 
stick to a limited use of the features (calling a few local functions/procedures 
within one package, using simple data types etc.) it works great. 

But I run into problems when I get a little bit more fancy, like calling 
functions/procedures in one package from another package in a few levels, 
using public variables as "global variables" to preserve values throughout a 
session, using PL/SQL tables and records etc. I have experienced some really
strange behaviour, like:

-  Running CREATE OR REPLACE PACKAGE BODY on a package with two procedures
   results in "Oracle server exited with status 1". If I change the order
   of the procedures in the package body, everything works fine.

-  Using PL/SQL Tables in one package as temporary storage of the result
   from a procedure call, and then accessing the tables trough another
   procedure call later results in "Oracle server exited with status 1"
   in some occasions.
   
-  In a package, I have to public variables declared like:

     TYPE IntTabType	IS TABLE OF BINARY_INTEGER INDEX BY BINARY_INTEGER;
     int_tab		IntTabType;
     int_index		BINARY_INTEGER;
     
   If I try to initiate these variables from SQL*Plus, I get the following
   results:
   
     SQL> begin test.intab(1) := 0; end;
       2  /
     begin test.intab(1) := 0; end;
     *
     ERROR at line 1:
     ORA-06501: PL/SQL: internal error 75946, arguments: [], [], [], [], [], [], []

     SQL> begin test.i := 0; end;
       2  /

     PL/SQL procedure successfully completed.
   
   i.e. it works fine to initiate the BINARY_INTEGER but not the PL/SQL Table.

In general, I get a feeling that the PL/SQL package is very flaky. Considering
that this is V7.0.10 (and the rumor has it that V7.0.12 will be the last
"prerelease version") I wonder how stable it will be in the real release.

Does anyone else have similar experiences? Have you heard if ORACLE are aware
of problems in the PL/SQL area? I have not seen anything in the README files
about it.

Regards,
Hans

-----
Hans Bergsten                 	     Internet : ebuhob@ebu.ericsson.se
Ericsson Business Communications     MEMO     : ERI.EBU.EBUHOB (God forbid.)
525 N. Muller St.                    Voice    : +1 (714) 491-6264
Anaheim, CA 92803, USA               FAX      : +1 (714) 535-1789
From: daveegan@dhw68k.cts.com (Dave Egan - N6XVZ)
Subject: Looking for Oracle User Group Honchos
Organization: Wolfskill & Dowling residence; Anaheim, CA (USA)
Distribution: usa
Date: Wed, 18 Nov 1992 07:03:38 GMT

I'm involved in a database vendor analysis.  One of the vendors is
Oracle.  I'm looking for the head(s) of any Oracle User Groups.  If
you are on this net, please send me a note; I'd like to talk with you.

Thanks,
  David Egan  (714)385-7220 (Work)

-- 
Dave Egan                                        | Radio: N6XVZ
    uucp: ...{spsd,zardoz,felix}!dhw68k!daveegan | n6xvz.ampr.org[44.10.0.176] 
InterNet: daveegan@dhw68k.cts.com                | n6xvz@n6xqy.CA.USA.NA