HDTenEightyP/NetNews huggingface dataset:
From: kml@cellar.org (Scott Tiger)
Newsgroups: comp.databases.oracle
Subject: Re: SQR and SQR Gossip
Date: 11 Dec 92 21:32:19 GMT
Organization: The Cellar BBS and public access system

pytlik@ra.cs.umb.edu (Marek Pytlik) writes:
> I think that Sybase (SQR parent comp) announced that they would not support
> SQL Report on Oracle 7 and up.  So it seems that SQR Report was JARW ( Just
> Aother Report Writer). Tired of that?  Build C++ classes around your data bas
> and do your reporting that way.

How many times does SQL*Solutions/Sybase have to say they're going to 
support Oracle 7 before you listen?  They've built the best report writer
I've ever used for Oracle,and it works with the V7 Development Releases
I've seen.  Anybody have the official SQR press release on this lying
around?

  Hofstadter's contracrostipunctus acrostically backwards spells 'J.S. Bach'
                  Something constructive should come here.
  kml%cellar@tredysvr.tredydev.unisys.com - My other account is a Mercedes.
From: omikko@cs.joensuu.fi (Olli Mikkonen)
Subject: Re: Pro*C
Organization: University of Joensuu
Date: Fri, 18 Dec 1992 14:50:40 GMT

richard@crowded-house.den.mmc.com (Richard Armstrong) writes:

...
>Why doesn't the Pro*C precompiler do #define substitutions? For instance,
>one cannot do the following:

>#define MAXLEN 80

>EXEC SQL BEGIN DECLARE SECTION;
>varchar string[MAXLEN + 1];
>EXEC SQL END DECLARE SECTION;

>Pro*C doesn't like MAXLEN, so I run the C pre-processor to do the substitution,
>but then Pro*C doesn't like the [80 + 1]. So I had to write my own pre-
>processor to do the math.

>I have a solution, but it requires running cpp, and my own custom pre-processor,
>and then finally running Pro*C.  Does this seem lame to anyone besides me?

>Is this fixed in v7?  I am stuck with v6 for now... Does anyone have a fix
>to this better than what I came up with?

Use m4.  It is standard, it is powerful and it does the trick.
You have to redefine some of m4's keywords but that's no big deal.
'man m4' for more information.

>This is my only real show-stopper complaint with Pro*C.

>Any input is appreciated.


>-- 
>My company never said any of this... I didn't either.
>Richard Armstrong, Software Engineer, Martin Marietta
>Email->>>> richard@crowded-house.den.mmc.com <<<<-Email 

-- 
Olli Mikkonen				Internet: omikko@cs.joensuu.fi
From: biwine@vaxsar.vassar.edu
Newsgroups: comp.databases.oracle
Subject: Looking for Mac report writer
Date: 18 Dec 92 14:26:45 +1000
Organization: Vassar College

Has anyone found a good, fully-featured data reporting tool that runs
on a Mac, and access Oracle over the net?  I have found some good
data dippers (Data Prism, Clear Access), but nothing that has full
reporting features (like SQR or SQL*ReportWriter).

Any recommendations?

Thanks in advance.

Bill Wine
Vassar College
biwine@vassar.edu
Newsgroups: comp.databases.oracle,bit.listserv.sqlinfo
From: Tom Moellering <moeller@convex.com>
Subject: Good SQL Referrence
Originator: moeller@neptune.convex.com
Date: Thu, 17 Dec 1992 20:36:47 GMT
Reply-To: moeller@convex.com (Tom Moellering)
Organization: Engineering, CONVEX Computer Corp., Richardson, Tx., USA
X-Disclaimer: This message was written by a user at CONVEX Computer
              Corp. The opinions expressed are those of the user and
              not necessarily those of CONVEX.


Does anyone care to share what there favorite SQL text is, and why?

I am up to speed on Oracle and SQL in general (took the PC-based training), and
I have written my share of Pro*C programs and SQLPlus scripts.  And all of my
selects have been coded the hard way.

However, I can't seem to find an advanced user's guide for SQL.  (By advanced
I do not mean the following:
	5 different ways to say 'not equal'
	29 business functions that you will never use
	DB security
	etc.)

What I do mean is that I can't seem to find a text that goes in depth on
difficult queries.  Combinations of all types of joins and subqueries, in
depth treatment of the different ways of speeding up complex query X.  And
why each one of them works, etc.

The books I already have which don't do the SELECT clause justice:

	The Practical SQL Handbook, by Emerson, Darnovsky, Bowman
	Sybex: Understanding ORACLE, by Lateer


Or is there a FAQ with this info available?
Tom (moeller@convex.com)
Newsgroups: comp.databases.oracle
From: funt@opus.bms.com (Craig Funt LV-5087)
Subject: Specifying help text within the ORACLE CASE tool
News-Software: VAX/VMS VNEWS 1.4-b1  
Keywords: help, case, sql*forms
Organization: Bristol Myers Squibb Pharmaceutical Research Institute
Date: Fri, 11 Dec 1992 17:12:00 GMT

This is my first posting so forgive me if I do something wrong...

We are developing a SQL*FORMS application using the ORACLE CASE Tool.  We have
a technical writer on our development team who will be writing the user 
documentation that axxompanies the application.  The technical writer will also
be helping out with on-line help.  The CASE tool's method of specifying hint
text, and multi-line field, block, and module help text is cumbersome.  I have
the following problems with it:

  1)  Since the help text block is made up of individual fields of 70
characters each, it is difficult to enter and edit the text efficiently.

  2)  Since we all know that most programmers cannot write, the technical
writer will be editing the help text.  To require the technical writer to enter
the various sections of CASE*DICTIONARY in order to find and edit the text is
not efficient either.

  3)  I realize that after the utility to extract the help text from the
CAS*DICTIONARY into the table where SQL*FORMS references the help text is run
that utilities exist to edit the help text.  The problem that I have with this
is that CASE*DICTIONARY is no longer a central repository for your application
information.

I've been thinking about extracting the information into the central help
table, allowing the text to edited, and then pushing the data back into the
CAS*DICTIONARY tables.  Has anyone ever done this?  Does anyone have any other
suggestions?

Your help and hints are greatly appreciated!

Thanks,
     Craig Funt

Newsgroups: comp.databases.oracle
From: caughey@engr.UVic.CA (Dave  Caughey)
Subject: Wide-Area-Network Performance Questions
Reply-To: caughey@engr.UVic.CA
Organization: University of Victoria, Victoria, BC, Canada
Date: Thu, 17 Dec 92 00:32:46 GMT



If one were to consider replacing a ver 5.1C 386-based standalone
database with a ver 6.0 SparcIPX-based RDBMS and DOS-based clients at
both local Ethernet sites as well as at remote sites (over 14.4kbs
phone lines), could anyone give some hints regarding the following:

1. What sort of performance difference can be expected in running
   a client (i.e., SQL*Forms and SQL*Reportwriter) over local Ethernet
   vs modem?

2. Is client Forms and Reports performance generally acceptable
   over Ethernet?

3. How crucial is the Forms design to performance (i.e., how much
   traffic can be eliminated through correct design? -- this is
   obviously a concern for the remote sites)

4. What about performance of the same Forms and Reports on a
   stand-alone Sun system (i.e., buy client tools for Sparc and use
   telnet sessions from DOS sites) versus the Ethernet-based client/server
   as described above?

4. How painful is the conversion from 
   a) Forms 2.3 to 3.0 on DOS?
   b) DOS Forms 2.3 to Sun Forms 2.3 or 3.0?
   c) DOS Reports to Sun Reports?

Thanks,

___________________________________________________________________________
Dave Caughey				Dept. of Elec. & Comp. Engineering
caughey@sirius.uvic.ca			P.O. Box 3055
                      			University of Victoria		  
"Ten million lemmings can't be wrong"   Victoria, B.C., CANADA V8W 3P6
From: tdonnell@ncrsoph.Sophia.NCR.COM (Tom Donnelly)
Newsgroups: comp.databases.oracle
Subject: Re: Too many open files
Keywords: open files
Date: 18 Dec 92 10:10:06 GMT
Reply-To: tdonnell@ncrsoph.Sophia.NCR.COM (Tom Donnelly)
Organization: NCR European Development Center

In article <1992Dec17.143430.12081@cbfsb.cb.att.com> gerette@cbnewsb.cb.att.com (marianne.g.pittorino) writes:
>
>Hi all!
>
>I am running RDBMS V6.0.36.0.1 and Pro*C precompiler 1.4.8.2.2 on a Pyramid
>(Release 2 UNIX).  I have an embedded SQL 'C' process that runs all day,
>processing updates to our database.  The process frequently executes a system
>call to SQL*Loader to load in bulk updates.
>
>It seems as if sqlload is not closing its files.  After about 100 calls or so
>(the number is not constant), I start getting the following error:
>	SQL*Loader-500:  Unable to open file (filename)
>	Pyramid UNIX Error: 24: Too many open files

< stuff deleted >
 Hi,
	I believe ( but am not 100% sure ) that there is a maximum number of
	file descriptors that can be assigned to a process, and that even
	though you are closing your files, each successive open() call 
	increments that file descriptor counter.  You may want to try re-
	using the file descriptors instead of performing explicit
	open() close() open() sequences.

	Anyway, thats my .02.  Any UNIX Gurus out there know for sure?

Tom
--------------------------------------------------------------------------------
These views are my own and do not represent those of my company.
No gaurantee, implied or other, unless specified by law. Details on back.
--------------------------------------------------------------------------------
Tom Donnelly               | WIN: Tom.Donnelly@Sophia
NCR Europe Group ISS       | UUCP: ..ncrcom!ncrsoph!tdonnell
Sophia Antipolis, Valbonne |                              
France			   | TEL: 33-92 94 45 40
From: p228@uni05.larc.nasa.gov (Bailey Bob)
Newsgroups: comp.databases.oracle
Subject: Re: OPS$LOGIN :security hole?
Date: 16 Dec 1992 21:47:45 GMT
Organization: Unisys-Hampton VA
NNTP-Posting-Host: uni05.larc.nasa.gov

In article <8aT=R#A@engin.umich.edu> lwk@engin.umich.edu (Lewis W Kellum) writes:
>
>Here's another question: If I know Mr.Schow's unix login id, and the internet 
>hostname of his Oracle server, what keeps me from creating his login id
>on my host and connecting to his ops$ oracle account?  - Woody Kellum

The only way the ops$ account works without a password is when you are
directly logged into the host server at the OS level.  If you connect to
the host via SQL*Net, the RDBMS will require entry of the password.

Bob Bailey


Newsgroups: comp.databases.oracle
From: eandersn@mach1.wlu.ca (Niels Ejvind Andersen)
Subject: Re: Classic Problem - Side by Side Blocks
X-Newsreader: Tin 1.1 PL5
Organization: Wilfrid Laurier University
Date: Sun, 13 Dec 1992 02:55:49 GMT

Jennifer Farnham (v045100@otis1.stortek.com) wrote:
: Block A has:              Block B has:
: Name       Age             Sex
: 
: Jenny      20               F
: Bob        30               M
: Sue        40               F
: 
: I don't want to put Sex as a non-database field in
: Block A, (i've got a reason for this).
: Since i'm not real familiar with 3.0, I thought there
: might be something out there I'm missing...

Hi Jenny,

My e-mail reply to you bounced, so I am posting my reply.

Hopefully, this application is not so far into the design stage that it cannot
be changed.  I see a one-to-one relation between NAME and SEX, and such a
relationship is usually an indication that the two attributes belong in the
same entity, i.e. in the same table.  Why are they not in the same table?
If they were, you wouldn't have this problem.
--
Niels Ejvind Andersen          eandersn@mach2.wlu.ca / 70511.2302@compuserve.com
Information Systems                                  Phone: (519) 884-1970 x2760
Wilfrid Laurier University                           Fax:         (519) 886-9351
Waterloo, ON  N2L 3C5  Canada                                        ... VFR NC4

--
Niels Ejvind Andersen          eandersn@mach2.wlu.ca / 70511.2302@compuserve.com
Information Systems                                  Phone: (519) 884-1970 x2760
Wilfrid Laurier University                           Fax:         (519) 886-9351
Waterloo, ON  N2L 3C5  Canada                                        ... VFR NC4
Newsgroups: comp.databases.oracle
From: cdm@pmafire.inel.gov (Dale Cook)
Date: Thu, 17 Dec 92 00:39:07 GMT
Organization: WINCO
Subject: Re: OPS$LOGIN :security hole?
Summary: 
Followup-To: 
Organization: WINCO
Keywords: 

In article <1go861INN4hv@rave.larc.nasa.gov> p228@uni05.larc.nasa.gov (Bailey Bob) writes:
>In article <8aT=R#A@engin.umich.edu> lwk@engin.umich.edu (Lewis W Kellum) writes:
>>
>>Here's another question: If I know Mr.Schow's unix login id, and the internet 
>>hostname of his Oracle server, what keeps me from creating his login id
>>on my host and connecting to his ops$ oracle account?  - Woody Kellum
>
>The only way the ops$ account works without a password is when you are
>directly logged into the host server at the OS level.  If you connect to
>the host via SQL*Net, the RDBMS will require entry of the password.

I beg to differ.  I regularly use my ops$ account over our local net,
and a password is NOT required.

In answer to the above question, the only way I know of is to not have
your server connected to the internet.  If you're worried about security,
you don't want the world having a path to your door.  Use a firewall system
as a front to the internet.  You may also need to have his user number,
but I don't know for sure.
--------------------------------------------------------------------------
...Dale Cook    "I don't much care how a man prays -- there's plenty of
                 room in hell for all of us."  --- "Mad Jack" Duncan
The opinions are mine only (i.e., they are NOT my employer's)
--------------------------------------------------------------------------
From: hugh@slee01.srl.ford.com (Hugh Fader)
Newsgroups: comp.databases.oracle
Subject: SQL*Loader foreign key problem
Date: 16 Dec 1992 20:47:25 GMT
Organization: Ford Motor Company Research Laboratory
Reply-To: hugh@slee01.srl.ford.com
NNTP-Posting-Host: slee06.srl.ford.com
X-Newsreader: Tin 1.1 PL5

I am having a problem with SQL*Loader and foreign keys. I have two
tables:

CREATE TABLE components(
 id                              NUMBER(4,0)      NOT NULL,
 confignum                       NUMBER(3,0)      NOT NULL
 [other stuff deleted]
)

CREATE TABLE conventional_data(
 id                              NUMBER(4,0)      NOT NULL,
 comp_id                         NUMBER(4,0)      NOT NULL,
 [other stuff deleted]
)

The conventional_data.comp_id column is a foreign key which references
components.id.

Here is my problem: I am trying to load data into the
conventional_data table using SQL*Loader. Each row in the external
file contains a confignum value which is assumed to pre-exist in the
components table. How can I assign a value to
conventional_data.comp_id that points to the appropriate row in the
components table? It seems as though I would have to use a SQL select
in order to do this. Have I hit the limit as to what SQL*Loader can
do?

--
Hugh Fader
Ford Research Laboratory
hugh@slee01.srl.ford.com

Newsgroups: comp.databases.oracle
From: euajhs@eua.ericsson.se (Jonas Hansson)
Subject: Re: mapping keyboard in xterm
Reply-To: euajhs@eua.ericsson.se
Organization: Ellemtel Telecom Systems Labs, Stockholm, Sweden
Date: Wed, 16 Dec 1992 19:32:43 GMT

Thanks everybody who send me mail about this problem. After reading the answers,
i decided to load this resource when connecting oracle with xterm.

XTerm*VT100.Translations: #override \
        @Num_Lock<Key>KP_0: string(0)\n\
        @Num_Lock<Key>KP_1: string(1)\n\
        @Num_Lock<Key>KP_2: string(2)\n\
        @Num_Lock<Key>KP_3: string(3)\n\
        @Num_Lock<Key>KP_4: string(4)\n\
        @Num_Lock<Key>KP_5: string(5)\n\
        @Num_Lock<Key>KP_6: string(6)\n\
        @Num_Lock<Key>KP_7: string(7)\n\
        @Num_Lock<Key>KP_8: string(8)\n\
        @Num_Lock<Key>KP_9: string(9)\n\
        @Num_Lock<Key>KP_Add: string(+)\n\
        @Num_Lock<Key>KP_Decimal: string(.)\n\
        @Num_Lock<Key>KP_Divide: string(/)\n\
        @Num_Lock<Key>KP_Enter: string(\015)\n\
        @Num_Lock<Key>KP_Equal: string(=)\n\
        @Num_Lock<Key>KP_Multiply: string(*)\n\
        @Num_Lock<Key>KP_Subtract: string(-)\n\

Now it's easy to toggle numeric keypad on/off and using oracle function keys
whitout problem.

/Jonas Hansson

Newsgroups: comp.databases.oracle
From: lwk@engin.umich.edu (Lewis W Kellum)
Subject: Re: OPS$LOGIN : security hole?
Date: Sat, 19 Dec 92 11:50:46 EST
Organization: University of Michigan Engineering, Ann Arbor

Thank you all for your input. The gist seems to be that OPS$ logins should not be used
in a networked environment (at least where there are untrusted packets). The best thing
oracle could do would be to develop an interface with kerberos for authentication of
network users.  - Woody Kellum


Newsgroups: comp.databases.oracle
From: beal@odin.Berkeley.EDU (Alan Beal)
Subject: Re: XA interface test code?
Date: Mon, 14 Dec 92 13:38:53 GMT
Reply-To: beal@odin.Berkeley.EDU (Alan Beal)
Organization: IBM T. J. Watson Research
Keywords: XA

Yes, we have written some Pro*C code using Encina.  There are some
gotchas that you must be
aware of especially if you use cursors and threads.  Give me a call if
you need help.

Alan Beal
(607) 751-2026
From: fgreene@hayes.com
Newsgroups: comp.databases.oracle
Subject: Re: Using and RDBMS for scientific apps?
Date: 17 Dec 92 09:38:36 EDT
Distribution: usa
Organization: Hayes Microcomputer Products, Norcross, GA

In article <1992Dec16.120505.15956@newstand.syr.edu>, podgorny@npac.syr.edu (Marek Podgorny) writes:
> We are considering use of the Oracle RDBMS as database engine
> for scientific applications (Earth science, physics). I would
> appreciate any pointers to similar work, completed or in progress.
> Oracle not essential, relational technology yes.
>  
> Marek Podgorny, NPAC, Syracuse University

In my experience, Oracle proper is not a good scientific tool.  However, it
does have a good interface to several packages, notably SAS.  The easiest
way to do it is to write a SQLPlus script to extract data in flat files
and then pass that data into the appropriate SAS routine with the SAS
DATA LIST function.  From there on, you have access to the complete library
of SAS functionality.

There is also a direct Oracle to SAS link available, but I have never had
the opportunity to utilize it.


  ---------------------------------------------------------------------------
  |      Frank Greene                  |          //////  //////             |
  |      DELPHI SYSTEMS, Inc.          |           ////    ////              |
  |      Telephone [615] 458-6032      |          ////    ////  //////       |
  |      324 Ootsima Way               |         ////    ////    ////        |
  |      Loudon, TN 37774              |        //////  //////  //////       |
  ----------------------------------------------------------------------------
  |         Of course, any opinions or suggestions are strictly my own       |
  ----------------------------------------------------------------------------
From: deflenniken@beckman.com
Newsgroups: comp.databases.oracle
Subject: Re: SQR
Date: 9 Dec 92 16:33:32 PDT
Organization: Beckman Instruments, Inc.

In article <6514.2b25ae0c@hayes.com>, fgreene@hayes.com writes:
> In article <1992Dec8.223829.11515@mr.med.ge.com>, sidney@picard.med.ge.com (W. T. Sidney MFG Project Eng. X46324) writes:
>> I'm interested in a report writer for oracle, other than SQL*ReportWriter.
>> I've been told to look at SQR.
>> 
>> Does any one have any info on SQR or any other Third (3rd) party report
>> writers?
>> 
>> Thanks
>> 
>> --
>> -=Sid=-
> 
> 
> SQR is a good product that includes a capability to generate matrix
> reports. There is a fairly steep learning curve, but once you get into the
> syntax it is easy to use.  Only shortcoming I have come across is that 
> the product has no statistical capabilities.  That is, give me the
> standard deviation, average, variance, etc., for a column or row of 
> numbers.
> 

SQR doesn't need simple statistical functions, since they are supplied
by Oracle in standard SQL query.

E.g.  begin-select
      AVG(col)
      STDDEV(col)
      VARIANCE(col)
      FROM Table
      WHERE ...
      end-select
  
[user soapbox on]

I've climbed the learning curve hill for SQR, RPT, SQL*Reportwriter and 
'C' with embedded SQL, and SQR was by far the easiest to learn and the
quickest to become productive at. It is a very rich procedural report writer
with a somewhat quirky syntax. There is not much that we have not been able
to do in SQR. We use it for batch programming, and call it from SQL*Forms as
well as useing it for report writing. 

Highly recommended (me speaking not my employer).

[user soapbox off]

..Darrell Flenniken 

Beckman Instruments



>   ---------------------------------------------------------------------------
>   |      Frank Greene                  |          //////  //////             |
>   |      DELPHI SYSTEMS, Inc.          |           ////    ////              |
>   |      Telephone [615] 458-6032      |          ////    ////  //////       |
>   |      324 Ootsima Way               |         ////    ////    ////        |
>   |      Loudon, TN 37774              |        //////  //////  //////       |
>   ----------------------------------------------------------------------------
>   |         Of course, any opinions or suggestions are strictly my own       |
>   ----------------------------------------------------------------------------
>
From: etche@onecert.fr (Groupe SUPAERO)
Newsgroups: comp.databases.oracle
Subject: RUN SQLFORMS 3.0 ON HP-9000 ?
Date: 14 Dec 92 10:33:06 GMT
Reply-To: etche@onecert.fr (Groupe SUPAERO)
Distribution: world
Organization: ENSAE (SUPAERO), FRANCE


 Hi,

 I work with oracle database V6 and SQLFORMS 3.0 on HP-9000.
 I have some character terminals VT-220 and some X-terminals.

 I have no problem to run sqlforms on VT-220 terminals, but
 i can't run it on my X-terminal, it displays escape characters,
 special characters, etc ...

 how can i success ?

 thanks in advance .


 ------------------------------
 ETCHEVERRIA guillaume
 ENSAE, 31500 TOULOUSE (FRANCE)
 etche@onecert.fr
 ------------------------------
Newsgroups: comp.databases.oracle
From: sautins@rintintin.Colorado.EDU (SAUTINS)
Subject: SQL*Net
Summary: Looking for experiences using SQL*Net
Organization: University of Colorado, Boulder
Date: Wed, 16 Dec 1992 19:10:45 GMT

	We are about to start using Oracle as the RDBMS for a new system
we are developing.  Our past experience is mainly with INGRES so I am
unfamiliar with the performance and benefits of some of the oracle
applications.  The items we are most interested in using are the SQL*net
and SQL*connect.  If anyone has any experiences/tips/techniques/or 
horror stories using any these applications, I would be most appreciative.
Also, is there a FAQ for such a beast?

	-thanks
		drew
		sautins@cadswes.colorado.edu