HDTenEightyP/NetNews huggingface dataset:
Newsgroups: comp.databases.oracle
From: dbmoore@us.oracle.com (Dennis Moore)
Subject: SQR for Oracle
Organization: not an official statement of Oracle Corporation, Redwood Shores CA
Date: Thu, 13 Aug 1992 19:11:58 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.

Due to the confusion in the market and at the request of many Oracle customers,
I followed up on the issue of SQR continuing to support ORACLE, including
ORACLE7.  My discussions with M. J. Kahn of Sybase (she was with SQL Solutions)
lead me to believe that they will make an attempt to continue to support their
Oracle customers despite their lack of an Oracle license.  M. J. Kahn was nice
enough to put together the following message, which she asked me to post to
this group.

>From:     M. J. Kahn <sybase!mj@Sun.COM>
>Subject:  Plans for SQR for Oracle
>Reply-To: sybase!mj@Sun.COM
>
>
>Dennis,
>
>   In our conversation yesterday, we discussed the possibility of my
>sending you a formal statement that you could include in your e-mail
>responses to customers who express concern about our plans for SQR for
>Oracle.  The following is that statement:
>
>        Sybase will continue to sell and support its products
>        that interface to non-Sybase databases.  This includes
>        SQR, Easy SQR, and the entire SQR product family.
>
>   I hope that this statement is clear and succinct enough to alleviate
>any concerns that our mutual customers might have.  If anyone has any
>further questions, you can feel free to refer them to me, at the
>e-mail address shown on the header of this message.
>
>                                        Regards,
>
>                                             M. J. Kahn
>                                             SQR Product Manager

If you would like to discuss this directly with M. J., please feel free to
contact her at the e-mail address given above.  Thanks,

-- Dennis Moore, my own opinions, etcetcetc
Organization: Queen's University at Kingston
Date: Wednesday, 19 Aug 1992 23:23:07 EDT
From: <CHARLESW@QUCDN.QueensU.CA>
Newsgroups: comp.databases.oracle
Subject: Tab-delimited files & ODL (Oracle Data Loader)

  We have some tab-delimited data that we want to load into some existing
tables.  Is there some way to indicate to ODL that the field delimiter is
the tab character?  (We ended up writing a filter program to convert the
tab to backslash for now, but we'll be getting these files regularly, and
it would be much cleaner to just load them directly.)

  Thanks.

.../dave   Dave Charlesworth
Newsgroups: comp.databases.oracle
Subject: Oracle and OS (again)
From: zorat@cs.unitn.it  (Alessandro Zorat)
Date: 20 Aug 92 17:48:38
Distribution: world
Organization: /home/users/zorat/.organization
Posting-Front-End: GNU Emacs 18.57.8 Lines: 31

I just posted the following message, just to see that the posting
front end ate away my host.
So here we go again.
Sorry for the bother.
(Just to be sure:  my net address is zorat@cs.unitn.it)


Hello net friends:

I have a question that perhaps many of you can answer:

Picture the following situation:  a network of about 150 PCs (banyan Vines
network, Compaq 3/486, windows 3.1, ...)
Most of the PC need access to some common data bases taht will be
implemented in Oracle.

The question then is: Oracle for which Operating system / environment
/ machine?

The choices are basically between installing Oracle under DOS, OS/2,
Vines (is it possible????), or Unix.
I presume that Unix should provide faster response to queries (coming
from the PC's, through OracleCard or similar), but does any of you
have any practical experience and/or numbers to support my guess?

Thank you in advance.
--


				Alessandro Zorat
			   (zorat@cs.unitn.it)
Newsgroups: comp.databases.oracle
From: sjs@netcom.com (Stephen Schow)
Subject: How do I trap arrow keys?
Date: Wed, 19 Aug 92 19:35:19 GMT
Organization: Netcom - Online Communication Services  (408 241-9760 guest) 

Anyone know how I can trap arrow keys..especially the right/left keys.
I believe I can use the KEY-UP and KEY-DOWN triggers to trap the up and
down arrow keys....but I can't figure a way to trap the left/right keys.
I also need a way to trap the return key.  

I am trying to design a dialog
box form that works just like a normal dialog box just like those you see
in the forms designer, or the other built in dialogs that Oracle often
throws up.

i.e...The arrow keys move the cursor and return selects the choice.

Any Help?
-- 
------------------------------------------------------------------
Steve Schow    | But you don't have to use the claw, if you
sjs@netcom.com | pick the pear with the big paw paw......
               | Have I given you a clue......?
               |                       - Baloo the Bear
------------------------------------------------------------------
From: deflenniken@beckman.com
Newsgroups: comp.databases.oracle
Subject: Re: SQR bought by Sybase; Future direction of SQR?
Date: 12 Aug 92 12:09:07 PDT
Organization: Beckman Instruments, Inc.
Summary: reposted to correct typos.

In article <1992Aug5.232734.9943@oracle.us.oracle.com>, dbmoore@us.oracle.com (Dennis Moore) writes:
> In article <kpalm.712606717@athena> kpalm@athena.qualcomm.com (Kent Palm) writes:
>>Now that Sybase owns SQR (Structured Query Report Writer) originally developed
>>by SQ Software, the question is what kind of support is Sybase going to
>>provide for the SQR Oracle interface?  Oracle v. 7 support?  Timeframe?
>>
>>I got the indication from the SQR Product Manager within Sybase that
>>they don't even have Oracle's v. 7 developer's version of the database
>>in house yet for upgrading their SQR product.  Does anyone know?
>>
>>We've got a substantial amount of work being done in SQR right now and need
>>to know future directions of the product.  
> 
> It is my understanding that Sybase has stopped selling SQR for non-Sybase
> data sources, including SQR for Oracle.  They are apparently not selling it
> even for ORACLE V6 any more.  I got this information from a member of our
> Affinity Board (the user group regional presidents who advise Oracle on our
> direction and status) whose company is very reliant on this product.  I am
> sorry for customers who invested a lot of development resources and time
> with SQR, but this is a problem frequently with smaller ISV's -- going out
> of business, or being acquired by a larger player with conflicting product
> lines or product directions.  I would suggest that people interested in SQR
> and/or the potential of migrating to other reporting tools should gather at
> the Reporting Tools SIG at this year's IOUW.  I further hope that users
> participating in this SIG (a non-Oracle-sponsored event run entirely by the
> user community) will bring up these difficult subjects, and report any
> concensus or conclusions in this forum.
> 
> -- Dennis Moore, my own opinions, etcetcetc

This message reposted to correct sonew typos.

I talked to M.J. Kahn the product manager for SQR at SQL solutions. She
said that greater than 50% of the SQR revenue is from Oracle users, and
it would NOT make good sense to throw that away.  She also said that SQL 
Solutions *IS* selling SQR to new Oracle customers.  Regarding V7, she does
not know when they will have a compatible version.  
We SQR users will need to keep our eyes and ears open to make sure that 
Oracle Corp. does not try to thwart SQL Solutions efforts at supporting V7.

SQR is a fine product, and nothing Oracle has can duplicate it's flexibility
and productivity.  

I'll keep the net posted of any info I obtain.

Regards
Darrell Flenniken

Comments mine only, of course.
From: kpalm@athena.qualcomm.com (Kent Palm)
Newsgroups: comp.databases.oracle
Subject: Re: Terminal types, recognition of...
Date: 14 Aug 92 00:26:00 GMT
Organization: Qualcomm, Inc., San Diego, CA

>If you've got a set of terminals that always get used, you can put them
>all in a single oraterm.r using the "oraterm" program.

Has anyone figured out a way to merge the numerous .r files into one .r
file?  Or do you open oraterm.r and type all the other devices,
products, functions in by hand?
From: hatzinger_m@bmwf1f.bmwf.gv.at
Newsgroups: comp.databases.oracle
Subject: Re: Key Triggers in Forms3.0 - redefinition
Date: 17 Aug 92 08:51:24 GMT
Organization: (Klaus-Michael Hatzinger), BMWF, Vienna

In article <a2824ag.713973047@sunmanager>, a2824ag@sunmanager.LRZ-Muenchen.DE (Riaan de Jager) writes:
> Hi
> 
> I've just switched over from v2.3 to v3.0 forms.
> 
> I want to redefine keys - to move between blocks, disable keys etc.
> 
> However, if I redefine eg. the KEY-Delrec trigger to do nothing i.e.
> 
> NULL;

================> NULL; --=> RAISE FORM_TRIGGER_FAILURE;


> 
> this takes no effect.
> 
> Do I need to set something somewhere? What am I doing wrong?
> 
> Thanks!
> -- 
>  ---------------------------------------------------------------------------
> |  Riaan de Jager           a2824ag@sunmanager.lrz-muenchen.de              | 
> |  Leibniz Rechenzentrum    jager@informatik.tu-muenchen.de    |         /  | 
> |  Barer Strasse 21 8000    Tel +49 89 2105 7402                \    *  /   | 
> |  Muenchen 2                                                    \     /    |
> |  Germany                                                        ;___/     |
>  ---------------------------------------------------------------------------
>                                       
>                                 
-- 

================================================================================
                                                                          ^
 Federal Ministry of Science and Research                               B | M
<-------------------------------------------------------------------------+---->
 Computer Center                                                        W | F
                                                                          |
 Klaus-Michael Hatzinger            mail: hatzinger_m@bmwf1f.bmwf.gv.at   |
 Bangkasse 1/209                   phone: 0043-222-53120/5188             |
 1014 Vienna, Austria                fax: 0043-222-53120/5155             V
================================================================================
From: deflenniken@beckman.com
Newsgroups: comp.databases.oracle
Subject: Re: Oracle Documentation
Date: 13 Aug 92 22:17:56 GMT
Organization: Beckman Instruments, Inc.

In article <92226.155322GIBSON@MAINE.MAINE.EDU>, Ginny Gibson <GIBSON@MAINE.MAINE.EDU> writes:
> Does anyone know of a good general reference manual for Oracle?
> Both "Using Oracle" by Que, and "Understanding Oracle" by Sybex
> are out of print.
> 
> Please reply via e-mail.
> Thanks,
> Ginny Gibson       GIBSON@MAINE.MAINE.EDU


Try "Oracle the Complete Reference" from Osborne McGraw-Hill

..Darrell
From: claborne@npg-sd.SanDiegoCA.NCR.COM (Chris Claborne)
Newsgroups: comp.databases.oracle
Subject: SQLnet for windows
Summary: SQLnet for Windows
Keywords: Oracle Windows
Date: 21 Aug 92 17:45:20 GMT
Distribution: world
Organization: NCR Corp., Network Products - San Diego

Does anyone know if ther is or about to be a version SQLnet for MS-Windows?
I don't plan on using it directly but in conjunction with Gupta.

Running it on my system, stacking it on top of Pathway and then running
Gupta is messy.  It would be nice to load that layer only when need while in 
Windows.  


    2
== C  ==
chris.claborne@sandiegoca.ncr.com                    CI$: 76340.2422
Newsgroups: comp.databases.oracle
From: kjou@oracle.com (Kathy Jou)
Subject: Re: Oracle table inserts and creations
Organization: Oracle Corporation
Date: Thu, 20 Aug 1992 17:02:25 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 <Bt90L3.JGK@monitor.com> bag!howard (Howard Brenner) writes:
>If I know ahead of time that I will be inserting a large amount of data  
>into a table is it more efficient to pre-allocate the space for the table  
>or to let oracle do it when it needs to?

One possible gain in efficiency with pre-allocating or pre-extending the table 
before the data is inserted is a very small savings in overhead when the table
grabs another extent during the insert if it was not pre-alloc'd/extended.

Make sure you precreate the table's storage parameters to have large enough 
extents to handle the large amount of data, ie you don't want to hit the 
*real* maxextents.  You might notice a slight drop in performance (more 
overhead) if the table has very small extents and the insert will fill up each 
extent with data much faster, spending more time creating extents.


-- Kathy Jou
-- Oracle Corporation
-- Disclaimer:  I speak from my own experience and not for Oracle.

Newsgroups: comp.databases.oracle
From: frozzboz@zork.demon.co.uk (Keith Davidson)
Subject: ** ORACLE Forms security ** 
Distribution: world
Organization: zork
Date: Wed, 12 Aug 1992 21:49:54 +0000


In article <1992Aug11.194948.18667@convex.com> lee@convex.com writes:

> 
> 
> I am trying to limit user access to my oracle database and am having
> a problem figuring out how. Here is the scenerio:
> 
> hundreds of users, each with their own userid and I only want them to be able
> to select/query records from the tables.
> 
> at the same time, I want them to have update,delete,insert,select,...
> ability on the same tables as long as they're accessing the tables through
> forms.
> 
If I read you right...

Assuming V6, try setting up, for each user, a product profile entry to
disable insert/update/delete access via sqlplus. (re doc file in oracle
directories). I do not know if renaming executable will circumnavigate this
and the use of a PRO*Oracle or RPT will get round it, so you may have to
utilise OS security also, to limit access to the executables
ie make sqlplus executable only, so no copy allowed, inhibit rpt access to
trusted background processes, and throw away the compiler!! (be really nasty
and let them have the precompiler ;-)*  )

I believe, and so does my cat that this feature will be extended to other
products (though coping with my_destructive_program.exe my be a problem)

Maybe V7 copes better? Any comments gurus@oracle.com?

--
frozzboz@zork.demon.co.uk  (Keith Davidson)

Watch out The Borg are about
From: mmcgovern@hayes.com
Newsgroups: comp.databases.oracle
Subject: Oracle Employment Opportunity
Date: 19 Aug 92 16:17:49 EDT
Organization: Hayes Microcomputer Products, Norcross, GA

Hayes Microcomputer Products Inc. has an opportunity for a Sr. Analyst for
our Atlanta, Georgia location.  This individual will support project
development, business applications through program development enhancements
and implementation.  Candidates should have a minimum of 2 years of 
experience with Oracle, to include Forms 3.0, as well as experience with
Manufacturing or Financial applications.  A BSCS or equivalent is required.
Additionally, we also have contractor positions open for experienced Oracle 
and CASE programmers.  For consideration, please send your resume to:
  Hayes Microcomputer Products, Inc.
  5835 Peachtree Corners
  Norcross, Georgia  30092

  Attn:  Employment

Or FAX your resume to:  (404)441-1213  Attn:  Employment.
From: holowczk@rwja.umdnj.edu (Richard Holowczak)
Newsgroups: comp.databases.oracle
Subject: Oracle and MS Excel 4.0, Q+E on PC
Summary: Oracle and MS Excel, Q+E on PC
Keywords: Oracle Excel PC
Date: 15 Aug 92 19:12:23 GMT
Distribution: comp
Organization: Robert Wood Johnson Medical School, Piscataway NJ

Hello again. Anyone out there use the Q+E program that comes with
MS Excel 4.0 on Windows?  I have Oracle 6.0xx on a PC with Windows 3.1
and Excel 4.0.  The Q+E documentation says you can connect to an Oracle
database but it does not give directions on how to do this! The help
screen in Q+E says to refer to the appendix of the manual corresponding
to the DB software you have. Very frustrating.

Could it be you can only do this kind of thing over SQL*Net?

If this works, a little macro programming could go a long way
towards providing a cheap familiar database interface for Excel
users.

Many thanks,

Rich Holowczak
Industrial Engineering
Rutgers University
HOLOWCZAK@DRACO.RUTGERS.EDU
Newsgroups: comp.databases.oracle
From: carol@ee.uts.edu.au (Carol Gibson)
Subject: Re: Are Oracle in England on email?
Organization: University of Technology, Sydney, Australia
Date: Mon, 17 Aug 1992 23:09:49 GMT

Thankyou to all the people who mailed me about oracle email
naming conventions - I'm sorry if I didn't get round to a 
personal thankyou, but a lot of people responded. So thanks
again for all your help guys :-)

	Carol
From: cdm@pmafire.inel.gov (Dale Cook)
Newsgroups: comp.databases.oracle
Subject: Re: READ ME---READ ME -- - READ ME -- READ ME
Date: 20 Aug 92 22:03:54 GMT
Organization: WINCO

In article <5y#nh5j.sjs@netcom.com> sjs@netcom.com (Stephen Schow) writes:
>I would like to suggest to everyone that is reading this group that they
>try to forward their responses to questions back to the group instead of
>just replying to the individual users.
>
>Whenever I ask a specific question, I always get 4-5 responses, which are
>very helpful to me, but not to anyone else who is reading the list and may
>also have interest in the topic.
>
>I know there are many times when I see someone ask a question and I wish
>I could see the responses he got.
>
>What do ya think?

I think that it is proper to reply by email.  I also think that it is
the duty of the person asking the question to summarize all such replies
and post a summary.  It's something that should be done and isn't done
enough, IMHO.
--------------------------------------------------------------------------
...Dale Cook    "There is no animal so spooky as the True Believer."
                   ---Edward Abbey
The opinions are mine only (i.e., they are NOT my employer's)
--------------------------------------------------------------------------
Newsgroups: comp.databases.oracle
From: p202@uni05.larc.nasa.gov (Bill Sneddon)
Subject: Oracle and Motif on DEC 5000
Keywords: Oracle and Motif 
Reply-To:  (p202@uni05.larc.nasa.gov)
Organization: NASA Langley Research Center, Hampton, VA USA
Distribution: comp.databases.oracle 
Date: Tue, 18 Aug 1992 17:22:50 GMT

I need to hear from anyone running the Motif version of Oracle 6.0 and Forms 
3.0 on a DEC RISC 5000 running Ultrix.  We are researching converting from 
our current character-based application interface to an X window-based GUI.  
We have a potential 40-50 users accessing the particular application on the 
RISC platform.  We are not planning on using Mac-X or DEC's eXcursion on the 
Mac and PCs.
From: hatzinger_m@bmwf1f.bmwf.gv.at
Newsgroups: comp.databases.oracle
Subject: RE: ** ORACLE Forms security **
Date: 12 Aug 92 13:21:32 GMT
Organization: (Klaus-Michael Hatzinger), BMWF, Vienna, Austria



You can limit user access to your oracle database creating a special view 
for your table which nows at run time, if it is running from SQL*Plus or IAP:


0. You need ORACLE V6

1. Create your table (table_name)

2. Create a view like

    CREATE VIEW view_name AS
    SELECT *
      FROM table_name
     WHERE EXISTS (SELECT 1
                     FROM sys.v_$session S,sys.v_$process P
                    WHERE addr=paddr
                      AND S.username=user
                      AND (INSTR(program,'IAP') <> 0 OR command=3)
                      AND terminal=USERENV('TERMINAL'))
    WITH CHECK OPTION;

"command" includes the actual command (SELECT=3,INSERT,...)
"program" includes the actual program name (IAP,SQLPLUS,...).


3. ORACLE-user "SYS" must give a "GRANT OPTION" on the virtual views

   GRANT SELECT ON v_$session TO PUBLIC WITH GRANT OPTION;
   GRANT SELECT ON v_$process TO PUBLIC WITH GRANT OPTION;


4. Set grants only on the view for all your users

   GRANT SELECT,INSERT,UPDATE,DELETE ON view_name TO ......


So they can update your database only in SQL*Forms (if it works on your 
system too ?).

                                            GOOD LUCK !!

-- 

--------------------------------------------------------------------------------
Klaus-Michael Hatzinger                            hatzinger_m@bmwf1f.bmwf.gv.at
Federal Ministry of Science and Research
Computer Center
Vienna, Austria
From: wkaufman@us.oracle.com (William Kaufman)
Newsgroups: comp.databases.oracle
Subject: Re: Terminal types, recognition of...
Date: 12 Aug 92 02:20:36 GMT
Organization: Oracle Corporation, Redwood Shores CA
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 <1992Aug10.174956.13401@unixg.ubc.ca> julia@unixg.ubc.ca (Julia Chen) writes:
] 
] Can anyone explain how Oracle interprets and treats terminal settings in a
] Unix environment? I work on a Sun IPC with xterm running on a remote Sun 4.

    (Note that the below only applies to SQL*Forms 3.0, SQL*Menu 5.0,
and Oracle*Terminal 1.0, and is fairly UNIX-specific.)

   If you don't specify a "-c" on the command line, it takes your $TERM
environment variable as your terminal, and oraterm.r as your resource
file.  (This is on UNIX systems--check your platform docs for defaults
on other platforms.)

] With my envrionment variable $term set at xterm, none of the Oracle tools will
] recgonize the terminal.

    Well, it'll look for a terminal named "xterm" in your oraterm.r.  If
it doesn't find it (and, in the default oraterm.r, it might not), the
program will warn you and halt.

] I either have to change $term to xtermsun:sun

    Don't do this!  Otherwise, other programs (like vi, for example) may
get confused about what kind of terminal you're using, and fail, or get
forced into line-mode.

] or add
] '-c xtermsun:sun' at invocation in order to get Oracle to correctly recgonize
] that I'm on an xterm.

    That's one solution.  If *all* your machine's users are using
xterms, though, you can simply rename your sun.r to oraterm.r (save the
old one somewhere!), and rename the "xtermsun" terminal listed in there
to "xterm" (and save the unmodified sun.r, too!).  Then, "xtermsun:sun"
becomes "xterm:oraterm", which would be your default.

                                                -- Bill K.

===============================================================================
William P.D. Kaufman         Voice: (415) 506-2447     500 Oracle Parkway
wkaufman@us.oracle.com         Fax: (415) 506-7221     Box 659411
Tools & Multimedia                                     Redwood Shores, CA 94065
Newsgroups: comp.databases.oracle
From: wayne@gbrmpa.gov.au (Wayne Amisano)
Subject: DBA Utilities - What do you use!!
Organization: Great Barrier Reef Marine Park Authority
Date: Thu, 13 Aug 1992 10:51:01 GMT


Hi,

I have recently gone on a DBA course and there was discussion about
the type of scripts people write to help administering there database!

This ranged from scripts to tell how fragmented the database is etc...

I would like to here from anyone outr there as to the type of
queries they have written to help administering there database!

I will collect all these and post a summary after a few weeks!!

tnx looking forward to hereing from you!!

cul wayne!

-- 
Wayne Amisano (VK4KT)     _-_|\\    E-Mail - wayne@gbrmpa.gov.au
Great Barrier Reef       /     \\   Phone  - +61 77 81 8861 (GMT+1000)
Marine Park Authority.   \_.-._/    Fax    - +61 77 72 6093
Our's to use Wisely!          v     Mail   - GPO Box 1379, Townsville QLD 4810
Newsgroups: comp.databases.oracle
From: frozzboz@zork.demon.co.uk (Keith Davidson)