HDTenEightyP/NetNews huggingface dataset:
From: hatzinger_m@bmwf1f.bmwf.gv.at
Newsgroups: comp.databases.oracle
Subject: Re: Use of nvl
Date: 19 Aug 92 09:59:40 GMT
Organization: (Klaus-Michael Hatzinger), BMWF, Vienna

In article <5885.2a8fddad@hayes.com>, alacy@hayes.com writes:
> Hi
> 
> We are in the process of evaluating a software package. We have been 
> looking at their code and have run across what appears to be some strange 
> code using the "nvl" function.  I have included some of their WHERE 
> clauses which do this:
> 
>              WHERE cust_no = nvl(null,:c.cust_no) ;
>              WHERE FOB_CD = nvl(null,:C.FOB_CD) ;
>              WHERE FREIGHT_CD = nvl(null,:C.FREIGHT_CD) ;
>              WHERE SHIPVIA_CD = nvl(null,:C.SHIPVIA_CD) ;
>              WHERE cust_no = nvl(null,:C.billto_cd) ;
>              WHERE TERMS_CD = nvl(null,:C.TERMS_CD) ;
>              WHERE cust_no = nvl(null,:C.billto_cd) ;
>              WHERE HOLD_CD = nvl(null,:C.HOLD_CD) ;
>              WHERE status_code = nvl(null,:C.order_status) ;
>              
> If I understand the "nvl" function then the following expression from the 
> first where clause
> 
>             nvl(null,:c.cust_no) 
>             
> means if null is equal to null then return the value of bind variable 
> ":c.cust_no"  which happens to be a screen variable.  This means the 
> expression will always return the value of ":c.cust_no".  Is there any 
> performance reason to do this?  I would think this would actually slow the 
> form down.  But the forms which came with the package have this type of 
> expression in a lot of places.  
> 
> Thanks!


I think there is no use for this type of expression. It's only to confuse and
to slow down the form. Maybe the developer of this form used any special type 
of generator or konverter.


-- 

================================================================================
                                                                          ^
 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
================================================================================
Newsgroups: comp.databases.oracle
From: v045100@otis1.stortek.com (Jennifer Farnham)
Subject: ORAPERL 
Reply-To: v045100@otis1.UUCP (Jennifer Farnham)
Organization: Storage Technology Corp.
Date: Thu, 20 Aug 1992 15:31:29 GMT


Is anyone out there familiar with ORAPERL?

Supposedly its Perl with embedded Oracle....?

Before I build it on our system, I would like
to hear from people who are somewhat familiar
with it. 

It is available at different ftp sites and you can
find those by using ARCHIE (log in as ARCHIE, not
anonymous).


---------------------------------------------------
Jennifer Farnham
Software Engineer
StorageTek
Boulder, Colorado
v045100@otis1.stortek.com - email.
From: kml@cellar.org (Lazlo Hoover Toth)
Newsgroups: comp.databases.oracle
Subject: Re: SQR bought by Sybase; Future direction of SQR?
Date: 12 Aug 92 13:22:13 GMT
Organization: The Cellar BBS and public access system

deflenniken@beckman.com writes:

> In article <1992Aug5.232734.9943@oracle.us.oracle.com>, dbmoore@us.oracle.com
> > In article <kpalm.712606717@athena> kpalm@athena.qualcomm.com (Kent Palm) w
> >>Now that Sybase owns SQR (Structured Query Report Writer) originally develo
> >>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 would like to pass on my experience with SQR and the Oracle V7 Developers
Release.  After going through the trauma of installing V7, SQR linked withi
no troubles whatsoever.  The only problem I have encountered with it thus
far is when running the EXPORT.SQR program, since the datatypes it looks 
for are hardcoded.  This is any easy fix for anybody.  I'd like to point
out that SQL*TextRetrieval 2.0 Beta has not yet linked correctly to V7
at my site.  And having suffered through two years of a beast called
SQL*ReportWriter...but I digress.  SQR works just dandy with V7.

Cheers.
Kevin.

This message may not be rebroadcast without the express written consent of 
the Baltimore Orioles and Major League Baseball.  Send $2 for transcripts to
  kml%cellar@tredysvr.tredydev.unisys.com  - My other account is a Mercedes.
Newsgroups: comp.databases.oracle
From: chang@wm-mercer.ca (Garry Chan)
Subject: SQL*Menu50
Organization: William M. Mercer Limited, Toronto, Ontario
Date: Wed, 19 Aug 1992 21:28:32 GMT

Is there any convenient way of knowing the current menu application name
at execution time in SQL*Menu50 ?

The pre-defined substitution parameter, &SO, only tells me the current
menu name and the option number.

Thanks !
Newsgroups: comp.databases.oracle
From: eric@homebase.vistachrome.com (Eric Brunson)
Subject: Re: READ ME---READ ME -- - READ ME -- READ ME
Organization: Vista-Chrome Incorporated
Date: Fri, 21 Aug 1992 12:15:38 GMT

cdm@pmafire.inel.gov (Dale Cook) writes:

>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.

If someone posts a question that you would like to hear the answers to, 
send the poster email asking for a summary.  If the poster gets enough
of these he should see that there is justification to post a summary to
the net.  You shouldn't feel that it is an imposition to ask someont
for a summary, since they got their answers by the grace of others willing
to take the time to respond.  "It's not what youv'e got, it's what you
give." - Tesla.



-- 
Eric "Raa" Brunson      |
eric@vistachrome.com   |     These opinions are mine alone, but
brunson@math.fsu.edu   |   they could be yours for a low monthly fee.  
Newsgroups: comp.databases.oracle
From: sinha@watson.bms.com (Anil Sinha)
Subject: RE: ** ORACLE Forms security **
News-Software: VAX/VMS VNEWS 1.4-b1  
Keywords: Form security.  
Organization: X
Date: Wed, 12 Aug 1992 16:13:00 GMT


>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,...).
> 

I don't wish to nit pick. But the user can avoid this security as follows:

     1.	copy the sqlplus executable to his/her area.
     2. rename the sqlplus executable to iap.exe
     3. assign symbol or logical as appropriate to the o/s

	egs. in VMS sqlplus == "$<device_name>:<directory>iap.exe"

     4. Now using iap.exe one can execute sqlplus

	Then sys.v_$process.program will have the string IAP	 


> 
>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: hatzinger_m@bmwf1f.bmwf.gv.at
Newsgroups: comp.databases.oracle
Subject: Re: Forms3 Delete a char of the field data
Date: 13 Aug 92 14:47:39 GMT
Organization: (Klaus-Michael Hatzinger), BMWF, Vienna

In article <1992Aug12.162132.278@falcon.navsses.navy.mil>, huynh@falcon.navsses.navy.mil writes:
> Greetings,
> 
> I am using sqlforms version 3.0.
> I have a problem which I don't even know where to start.  I want to delete a
> char of the enter data into a field.  
> eg. Let 's say I have a field that requires data
> HULL: _________; where the users will enter something like HULL: LST-1183,
> I want to delete the "-" sign/char.
> I want the data to be in the form of 'LST1183', but because of the way our data
> bases are set up, the users will enter the HULL in the form of 'LST-1183'. I
> want to delete the "-" sign/char, and also at the time somehow join the 
> LST 1183 together so that it is like the user had just entered 'LST1183' and
> not 'LST-1183'.
> I need to convert 'LST-1183' into 'LST1183', so that it corresponds with the
> database HULL to do the query.
> 
> I hope I have made myself clear.  Anyone who is interested, but didn't quite
> undertand me, please feel free to ask.  I will be more than happy to make
> myself clear.  
> 
> Any comments or suggestions will be appreciated.  Thanks in advance.

Create a POST-CHANGE trigger on the field HULL:

IF :hull != REPLACE(REPLACE(:hull,'-',''),' ','') THEN
   :hull := REPLACE(REPLACE(:hull,'-',''),' ','');
END IF;

-- 

================================================================================
                                                                          ^
 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
================================================================================
Newsgroups: comp.databases.oracle
Subject: Oracle and operating systems
From: zorat  (Alessandro Zorat)
Date: 20 Aug 92 17:42:32
Distribution: world
Organization: /home/users/zorat/.organization
Posting-Front-End: GNU Emacs 18.57.8 Lines: 25

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)
From: alacy@hayes.com
Newsgroups: comp.databases.oracle
Subject: Use of nvl
Date: 17 Aug 92 17:11:08 EDT
Keywords: SQLFORMS,NVL function
Organization: Hayes Microcomputer Products, Norcross, GA

Hi

We are in the process of evaluating a software package. We have been 
looking at their code and have run across what appears to be some strange 
code using the "nvl" function.  I have included some of their WHERE 
clauses which do this:

             WHERE cust_no = nvl(null,:c.cust_no) ;
             WHERE FOB_CD = nvl(null,:C.FOB_CD) ;
             WHERE FREIGHT_CD = nvl(null,:C.FREIGHT_CD) ;
             WHERE SHIPVIA_CD = nvl(null,:C.SHIPVIA_CD) ;
             WHERE cust_no = nvl(null,:C.billto_cd) ;
             WHERE TERMS_CD = nvl(null,:C.TERMS_CD) ;
             WHERE cust_no = nvl(null,:C.billto_cd) ;
             WHERE HOLD_CD = nvl(null,:C.HOLD_CD) ;
             WHERE status_code = nvl(null,:C.order_status) ;
             
If I understand the "nvl" function then the following expression from the 
first where clause

            nvl(null,:c.cust_no) 
            
means if null is equal to null then return the value of bind variable 
":c.cust_no"  which happens to be a screen variable.  This means the 
expression will always return the value of ":c.cust_no".  Is there any 
performance reason to do this?  I would think this would actually slow the 
form down.  But the forms which came with the package have this type of 
expression in a lot of places.  

Thanks!
From: nirad@newdelphi.ceu.uq.oz.au (Nirad Sharma)
Newsgroups: comp.databases.oracle
Subject: Parallel architectures and Oracle
Date: 16 Aug 92 15:05:03 GMT
Organization: Continuing Education Unit, The University of Queensland

Has Oracle v.6/7 been ported to any parallel architectures ?  If so,  where
could I get tech reports on the port regarding its functionality / robustness /
performance ?
--
Nirad Sharma  (nirad@ceu.uq.oz.au)			Phone : (+61 7) 365 7575
Continuing Education Unit				Fax :	(+61 7) 365 7099
The University of Queensland.  QLD  4072.  AUSTRALIA
From: aaj@cmutual.com.au (Tony Jambu)
Newsgroups: comp.databases.oracle
Subject: Oracle in Financial Instuitions (Banks, Insurance & Investment houses)
Date: 17 Aug 92 01:19:44 GMT
Organization: Colonial Mutual Life Australia

Dear Oracle Sites,

I am trying to contact any Banking, Insurance or Investment sites; in
particular any Investment houses.  We are an Insurance company with a
substantial investment area.

Are there any such sites out there that use Oracle?  If you know of any
such sites, I would appreciate if you could email me either an Internet
name/address or a contact person/number.  Even a company name will do.


If you are such a site, these are some of my questions:

1.  What is your company's name?
2.  What line of business does your company deal in (Banking, Insurance and
    Investment)?
3.  Where are you based at?
4.  How big is your company?
5.  How big is you IT department?
6.  Does Oracle play a major or minor part in your company's IT strategy.
7.  What do you use Oracle for (Decision Support, OLTP, R&D or evaluating it)?
8.  Are your application written in-house?
9.  How long has your company been using Oracle?
10. What type of platforms (hardware and Op/sys) does your company use ?
11. do you exchange information between your Oracle database and others?
12. What are you experiences with Oracle? Good or bad and why?



Any replies would be greatly appreciated.


-- 
-----------------------------------------------------------------------------
 _____       ________ / ____ |Tony Jambu, Database Administrator
  /_  __       /_ __ /       |Colonial Mutual Life Australia. (ACN 004021809)
 /(_)/ ((_/ \_/(///(/_)/_(   |EMAIL:  TJambu@cmutual.com.au
From: hatzinger_m@bmwf1f.bmwf.gv.at
Newsgroups: comp.databases.oracle
Subject: Re: SUBSTRING FUNCTION IN FORMS 3.0
Date: 17 Aug 92 08:51:21 GMT
Organization: (Klaus-Michael Hatzinger), BMWF, Vienna

In article <1992Aug13.081954.279@falcon.navsses.navy.mil>, mdipilla@falcon.navsses.navy.mil writes:
> TO WHOMOVER KNOWS WHATEVER,
> 
>     WOULD ANYONE KNOW IF THERE IS A SUBSTRING FUNCTION IN FORMS.
> WE BASICALLY HAVE A FIELD WHICH THE USER WOULD INPUT.  HE WILL BE
> TYPING IN A "-" SOMEWHERE IN HIS FIELD.  IT CAN BE IN THE THIRD POSITION
> XX-XXXX OR IT CAN BE IN THE FOURTH POSITION XXX-XXXX.  HOW CAN I REMOVE
> THIS HYPHEN.
> 
> THANK YOUR VERY MUCH

Create a Trigger (POST-CHANGE, POST-FIELD or ON-VALIDATE-FIELD) ..

- Forms V3

IF :Field != REPLACE(:Field,'-','') THEN
   :Field := REPLACE(:Field,'-','');
END IF;

- Forms V2

  SELECT REPLACE(:Field,'-','') INTO :Field 
    FROM dual
   WHERE REPLACE(:Field,'-','') != :Field

or if you have ORACLE V5 you can take TRANSLATE instad of REPLACE for one
character.



-- 

================================================================================
                                                                          ^
 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: mtoms@ems.cdc.com (Mark Toms)
Newsgroups: comp.databases.oracle
Subject: Re: SUBSTRING FUNCTION IN FORMS 3.0
Date: 14 Aug 92 12:43:07 GMT
Reply-To: mtoms@ems.cdc.com
Distribution: usa
Organization: Empros Systems International, a division of CDC

In article <1992Aug13.081954.279@falcon.navsses.navy.mil>, mdipilla@falcon.navsses.navy.mil writes:
|> TO WHOMOVER KNOWS WHATEVER,
|> 
|>     WOULD ANYONE KNOW IF THERE IS A SUBSTRING FUNCTION IN FORMS.
|> WE BASICALLY HAVE A FIELD WHICH THE USER WOULD INPUT.  HE WILL BE
|> TYPING IN A "-" SOMEWHERE IN HIS FIELD.  IT CAN BE IN THE THIRD POSITION
|> XX-XXXX OR IT CAN BE IN THE FOURTH POSITION XXX-XXXX.  HOW CAN I REMOVE
|> THIS HYPHEN.
|> 
|> THANK YOUR VERY MUCH
There is one.

  Page 4-18 in the SQL Language Reference Manual Version 6.0

     SUBSTR(char,m,n)


  Example: SELECT SUBSTR('ABCDEFG',2,3) "Sugstring" FROM DUAL

  Returns: BCD


==========================================================================
J. Mark Toms                                email: mtoms@ems.cdc.com
Baltimore Gas & Electric, Company
C/O Empros Systems International            Phone: (612) 553-4423
2300 Berkshire Lane North                     FAX: (612) 553-4018
Plymouth, Minnesota  55441-3694 USA      Mailstop: PLY060
==========================================================================
Newsgroups: comp.databases.oracle
From: gopi@indetech.com (Prakash Gopinath)
Subject: Re PL/SQL problem
Organization: Independence Technologies, Inc. Fremont, CA
Distribution: usa
Date: Thu, 13 Aug 1992 18:39:32 GMT

Newsgroups: comp.databases.oracle,connect.audit
Subject: Re: PL/SQL problem
Summary: 
Expires: 
Followup-To: 
Distribution: 
Organization: Independence Technologies, Inc. Fremont, CA
Keywords: 

In article <BsvF6u.GoE@ibmpcug.co.uk> boxfield@ibmpcug.co.uk (Paul J Snelling) writes:
> 
>This is probably a stupid question but Ive been trying all kinds of ways
>to get information OUT of a PL/SQL block without writing it to a table.
>I'm hoping that someone out there has tried the same thing and can tell me
>(A) how to do it, or (B) it cant be done....
> 
  Oracle PL/SQL does not allow you to display variables in a PL/SQL block.

>My latest attempt under sqlplus goes something like...
> 
>SQL> define MYVAR=500
>SQL> declare
>2    i  number ;
>3    begin
>4    for i in 1..10 loop
>5      MYVAR := &MYVAR + i ;
>6    end loop ;
>7    end ;
> 
>A pathetic attempt, but you can see what Im trying to acheive (I hope).
> 
>Any ideas?
> 
 You can use PRO *C and include this block and display the values of variables.

>-- 
>Paul Snelling,	BoxField Systems Ltd


-- 
____*_  Gopinath Prakash            gopi@indetech.com
\  / /  Independence Technologies   
 \/ /   42705 Lawrence Place        FAX: 510 438-2034
  \/    Fremont, CA 94538           Voice: 510 438-8777
From: mdipilla@falcon.navsses.navy.mil
Newsgroups: comp.databases.oracle
Subject: SUBSTRING FUNCTION IN FORMS 3.0
Date: 13 Aug 92 13:19:54 GMT
Organization: NSWCCD, Naval Ship Systems Eng Sta, Phila PA

TO WHOMOVER KNOWS WHATEVER,

    WOULD ANYONE KNOW IF THERE IS A SUBSTRING FUNCTION IN FORMS.
WE BASICALLY HAVE A FIELD WHICH THE USER WOULD INPUT.  HE WILL BE
TYPING IN A "-" SOMEWHERE IN HIS FIELD.  IT CAN BE IN THE THIRD POSITION
XX-XXXX OR IT CAN BE IN THE FOURTH POSITION XXX-XXXX.  HOW CAN I REMOVE
THIS HYPHEN.

THANK YOUR VERY MUCH
Newsgroups: comp.databases.oracle
From: wkaufman@us.oracle.com (William Kaufman)
Subject: Re: Terminal types, recognition of...
Organization: Oracle Corporation, Redwood Shores CA
Date: Thu, 13 Aug 1992 21:03:57 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 <1992Aug12.212237.17532@unixg.ubc.ca> george@unixg.ubc.ca (George chow) writes:
] In article <1992Aug12.022036.9693@oracle.us.oracle.com>, wkaufman@us.oracle.com (William Kaufman) writes:
] |> 
] |>     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.
] 
] Ah, so oraterm.r is an index of sorts...

    Ummm, not sure how you mean "index".  It's the default resource
file: unless you specify one with the "-c" option, your terminal name
better be listed in there.

] Maybe I should have said that I was really more interested in the file oraterm.r.
] I was slightly confused because my ORATERMPATH points to a directory which 
] contains xterm.r, vt100.r, and a few others.

    ...and oraterm.r, I hope!

] Since I know that if I come in from
] a vt100 terminal that things are okay, I couldn't understand why coming in from
] an xterm would be different. So, the answer is that oraterm.r needs to have an
] entry for xterm inside it before it will even start looking for xterm.r.

    The tools (Forms, Menu, etc.) will only look at one file--oraterm.r,
or whatever you specify; {terminal}.r won't be looked at.  And, most
product lines ship an oraterm.r that only contains definitions for the
VT terminals--that's why your VT worked OK, but your xterm didn't.

    A single resource file *can* contain more than one terminal, though.
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.  Then, you only
have to be sure that the default terminal is set properly--on UNIX, that
means setting your $TERM variable correctly.

    (Convert the above into your OS's language,...)

                                                -- 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
From: kpalm@athena.qualcomm.com (Kent Palm)
Newsgroups: comp.databases.oracle
Subject: Re: Problem Using SQR on HP LaserJet
Date: 13 Aug 92 18:35:52 GMT
Organization: Qualcomm, Inc., San Diego, CA

This looks like a problem with one of the quotas set by executing
SYSUAF.  Check with your System Manager (or DEC) to find out which one
it is and increase the parameter.  Someone at Sybase should be able to
answer this question too, but it needs to be their VMS guru, not an SQR
techie.
Newsgroups: comp.databases.oracle