HDTenEightyP/NetNews huggingface dataset:
From: rz34@hp850.rz.uni-karlsruhe.de (Schillinger)
Subject: Re: National Language Support in ORACLE v.6
Reply-To: rz34@rz.uni-karlsruhe.de
Organization: University of Karlsruhe, Germany
Date: Thu, 30 Jul 1992 12:48:25 GMT

In article <1992Jul28.121659.6252@rz.uni-karlsruhe.de> rz34@rz.uni-karlsruhe.de writes:
>In article <1992Jul23.132010.2226@rz.uni-karlsruhe.de> rz34@rz.uni-karlsruhe.de writes:
>>We're using ORACLE version 6.0.34.2.1 on an HP-UX Series 9000/800.
>>
>>I'm trying to get National Language Support to work and can't.
>>I've followed the instructions in the DBA Guide, i.e. I added
>>
>>nls_sort = true
>>germany_germany.WE8HP
>>
>>to init.ora.  Am I using the wrong character set?
>>Can anyone help?  
>>
>>Thanks!
>>Karen
>
>Thanks again to those who replied.  Everyone told me to change
>language=germany_germany.we8hp    
>to
>language=german_germany.we8hp
>
>which I tried.  I also tried different combinations of upper and lower
>case.  Still no luck.  Any other suggestions?
>
>Karen

Thanks once again for all the help!  My mistake was that I didn't do a
shutdown!  I thought logging off and on again was enough.  Live and learn!

It's running now though.  I just have to figure out which is the correct
character set to get umlauts. (On hpterm they appear correctly, but on
vt100 and X-term they don't - in Forms3.0 and SQL*Plus at least.)

Karen
From: kml@cellar.org (bdfh)
Newsgroups: comp.databases.oracle
Subject: Re: Deleting Duplicates
Date: 27 Jul 92 15:32:40 GMT
Organization: The Cellar BBS and public access system


Can we add this topic to an FAQ file?  It came up about two months ago
and was coded into the ground.

Kevin.


  c/o YoyoDyne Propulsion Systems, maker of the Tri-Wing Fighter
          All parts delivered in big pink boxes.
  kml%cellar@tredysvr.tredydev.unisys.com  - My other account is a Mercedes.
From: cooper@seismo.CSS.GOV (Dale Cooper)
Newsgroups: comp.databases.oracle
Subject: sql*loader question
Keywords: sysdate
Date: 24 Jul 92 19:24:29 GMT

Hey there fellow Oracle swillbellies,

Anyone know how to load sysdate into a table using SQL*Loader?

Dale Cooper, DBA
Center for Seismic Studies
Arlington, VA
From: ckohout@ems.cdc.com (Cathy Kohout)
Newsgroups: comp.databases.oracle
Subject: Passing parameters into SQL*Forms
Date: 21 Jul 92 20:46:24 GMT
Reply-To: ckohout@ems.cdc.com
Distribution: na
Organization: Empros Systems International, a division of CDC

Hello,

Does anyone know of a way to pass external information to a Form?

I need to tell the Form something about who I am, other than the
user name and password, in order for it to display the appropriate
information.  Specifically, I'd like to be able to pass the UNIX
process id (PID) number, since it is this number that is being used
to name an ORACLE table (created earlier in the process).

Any suggestions would be greatly appreciated.
From: agmkne@usho32.hou281.chevron.com (M.K.Netzband)
Newsgroups: comp.databases.oracle
Subject: Re: Deleting Duplicates
Date: 23 Jul 92 18:09:19 GMT
Organization: Chevron

In article <1992Jul23.091611.1@jaguar.uofs.edu> littlec1@jaguar.uofs.edu (Chris Little) writes:
>In article <VN70NB1w165w@iowegia.uucp>, bob@iowegia.uucp (Bob Powers) writes:
>> How can I delete duplicate rows in a table using SQL*PLUS.  This is
>> an unindexed table and I would like to keep it that way.
>
>I'm relatively new at the job, but I suspect you could create a similar
>table, do an INSERT SELECT UNIQUE from the old table to the new table,
>delete all rows from the old table, copy all rows from the new table
>to the old, and then drop the new one.  Maybe there's a better way.
>

Try customizing the following...

delete from TABLE_NAME a
 where a.rowid < (select max(b.rowid)
                   from TABLE_NAME b
                   where b.field1 = a.field1
                   and   b.field2 = a.field2);



Mike
 
Newsgroups: comp.databases.oracle
From: GO.MSB@isumvs.iastate.edu 
Subject: Re: Oracle V6.0 and Borland C++ 3.0 ???
Organization: Iowa State University, Ames IA
Distribution: usa
Date: Thu, 23 Jul 1992 14:55:06 GMT

In article <1992Jul23.133752.4755@news.weeg.uiowa.edu>,
pkoch@news.weeg.uiowa.edu (Peter F Koch) writes:
>I bought Borland C++ V3.0 recently.  I will soon be getting Oracle V6.0
>for MS-DOS and want to develop Windows database applications. Does Oracle
>support Borland C++ or do I have to use Microsoft's compiler?
>
>===========================================================================
>Peter Koch                                              Phone: 708-534-5200
>Weston Gulf Coast Labs                     email:pkoch@umaxc.weeg.uiowa.edu
>2417 Bond St.
>University Park, IL 60466
>===========================================================================
---------------------------
The Pro*C for MS-DOS and OS/2 Getting Started booklet (pp 2-2,2-3) indicate
requirements as MS C ver 6, MS link and MS assembler (for user exits).
They indicate specific MS C libraries (llibcr, libh, llibfa), so that probably
throws other compilers out the window (for protected mode applications, anyway).

Marvin Beck    Iowa State University
Newsgroups: comp.databases.oracle
From: lwv26@cas.org (Larry W. Virden)
Subject: Re: Forms3 with Mouse Interface
Followup-To: comp.databases.oracle
Reply-To: lvirden@cas.org (Larry W. Virden)
Organization: Nedriv Software and Shoe Shiners, Uninc.
Date: Fri, 31 Jul 1992 17:29:35 GMT

I know that xterm can generate special escape sequences for the mouse
button presses.  I dont know of any code to read those presses to do something.

I don't know much more about it other than what is in the xterm ctlseqs.ms
file though.
-- 
Larry W. Virden                 UUCP: osu-cis!chemabs!lvirden
Same Mbox: BITNET: lvirden@cas  INET: lvirden@cas.org
Personal: 674 Falls Place,   Reynoldsburg, OH 43068-1614
America Online: lvirden@aol.com
Newsgroups: comp.databases.oracle
From:  Neil Greene <deepthought!neil@ms.uky.edu> 
Subject: Universal Key Definitions (oraterm)
Reply-To:  Neil Greene <deepthought!neil@ms.uky.edu> 
Organization: ARCI, Inc.
Date: Thu, 30 Jul 1992 17:42:31 GMT

I am running Oracle on a NeXTcube.  I was checking on the universal terminal  
resource files (*u.r) and noticed I do not have these resource files.  Could  
someone mail me a copy of their vt100u.r file.

Thanks
-- 
Neil Greene -----------	Director, Computer Information Systems ARCI, Inc.
606.254.4060 (P)	President, Kentucky NeXT User Group, Inc.
606.254.4864 (F)	Email: deepthought!neil@ms.uky.edu [NeXTmail]
Newsgroups: comp.databases.oracle
From: dewey@centerline.com (Devan F. Dewey)
Subject: Re: (SOLUTION ENCLOSED) Re: SQL*Reportwriter last page eject
Followup-To: comp.databases.oracle
Organization: CenterLine Software, Inc.
Date: Wed, 29 Jul 1992 20:24:47 GMT

In article <fragante.712433433@unixg.ubc.ca>, fragante@unixg.ubc.ca (Gv
Fragante) wrote:
> 
> >There are three possible changes that will fix this problem!
> 
> >One:
> >	 Add an "fs=:"
> >	(ie: nothing) to the 'wide' and 'dflt' definitions (if that's all
> >	you use).
> 
> Looks like the most viable method.
> 
> 

I've already tried this, and it doesn't seem to work. I added the fs=:
parameter to the printdef.dat file and recompiled, but I am still getting
the extra page (e.i., the form feed and the end of the file)

We are writing all our reports to file and then using the a2ps unix utility
to translate ascii to postscript. Our final destination are Apple
LaserWriters and PS enhanced HP's

Is there anything else I should be doing?

> 
> 
> >-Andy
> > just an oracle customer
> 
> 
> Thanks.
> 
> GV

                             
               Devan F. Dewey | Senior Systems Analyst
          CenterLine Software | dewey@centerline.com
            10 Fawcett Street | "Leme esplain - no dere is
          Cambridge, MA 02138 | too much. Leme sum up."
                                       -Inigo Montoya
From: dcox@relay.nswc.navy.mil (David Cox)
Newsgroups: comp.databases.oracle
Subject: Can one user create table in another's tablespace?
Date: 30 Jul 92 15:50:10 GMT
Followup-To: comp.databases.oracle
Organization: NSWC

Don't ask me how I got into this situation, but I need to allow
another user to create a table (as part of a weekly procedure)
in my username. That is, my oracle username/login is, say, david,
and their's is bob. I need to be able to allow bob to do:

sqlplus bob/hispassword
>drop table david.acctdata
>create table david.acctdata (etc...)
>grant select,insert on david.acctdata to bob
>grant select on david.acctdata to frank
>quit

Actually, at some point in the weekly procedure I would like to
restrict bob to select privilidges on david.acctdata, but this is
not crucial. 

Is there some way I can achieve this without bob having DBA priviledges?
From: kpalm@athena.qualcomm.com (Kent Palm)
Newsgroups: comp.databases.oracle
Subject: SQR bought by Sybase; Future direction of SQR?
Date: 31 Jul 92 18:18:37 GMT
Organization: Qualcomm, Inc., San Diego, CA

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.
From: chia@hatteras.cs.unc.edu (Mr. Chia)
Newsgroups: comp.databases.oracle
Subject: SQL*FORM: highlighted field
Date: 23 Jul 92 13:40:57 GMT

In sql*form/image/painter, the field/column of a table is always highlighted.
I want to turn this attribute off. I tried display_field(:test.a, inverse).
sql*form doesn;t accept "inverse". Can somebody tell me what I can do?
Newsgroups: comp.databases.oracle
From: nakkala@cs.tamu.edu (Venkatesh Nakkala)
Subject: Doubt  using SQLFORMS 3.0 ......... MAster/Detail Rel.
Organization: Computer Science Department, Texas A&M University
Date: Sat, 25 Jul 1992 15:57:10 GMT





  Howdy,
        I`ve created a Master_Detail relationship between a Master Block and
        two detail blocks. Now I want to delete the master detail relationship
        and keep them as just independent blocks for the user to insert/query
        from. How do I do this...what triggers and procedures on the 
        Master Block and the Form do I have to delete.........

         If I have all the foreign key constraints defined while defining
        the tables I dont need to define the same dependencies  between the
        blocks...am I right in assuming this ?.......

        Thanks in advance,


        Venkatesh Nakkala 


--
-----------------------------------------------------------------------------
		     Venkatesh  Nakkala    nakkala@neuron.tamu.edu 
 Off : (409)845-5469                       Res : (409)268-7404
 Dept. Of Comp Sci.,Texas A & M Univ. 
Newsgroups: comp.databases.oracle
From: al@cvgis.prime.com (Al Parker)
Subject: Embedded SQL WHENEVER NOT FOUND problem
Organization: Computervision GIS (Toronto)
X-Newsreader: Tin 1.1 PL4
Date: Thu, 30 Jul 1992 13:32:15 GMT

Greetings,
I am finding that in certain usage of the Pro*C precompiler with
'mode=ansi13' and the following code:

EXEC SQL WHENEVER NOT FOUND GOTO :c_statement1;
EXEC SQL WHENEVER SQLERROR GOTO :c_statement2;
...
EXEC SQL EXECUTE IMMEDIATE :sql_statement;
...
the Pro*C precompiler does not generate a check for the NOT FOUND
condition after the EXECUTE IMMEDIATE. (It does correctly generate 
the check for the SQLERROR condition.)

The work-around is to perform the check explicitly:

if( sqlca.sqlcode == 100 ) goto c_statement1;

but it would be nice if the WHENEVER worked as documented.

Has anyone else encountered this problem ?
-- 
-------------------------------------------------------------------------------
Al Parker, P.Eng, Sr Software Engineer - Computervision GIS
al@cvgis.prime.com	(416)508-8020(x881)
These opinions are my own and not those of my compnay.
Newsgroups: comp.databases.oracle
From: rz34@hp850.rz.uni-karlsruhe.de (Schillinger)
Subject: National Language Support in ORACLE v.6
Reply-To: rz34@rz.uni-karlsruhe.de
Organization: University of Karlsruhe, Germany
Date: Thu, 23 Jul 1992 13:20:10 GMT

We're using ORACLE version 6.0.34.2.1 on an HP-UX Series 9000/800.

I'm trying to get National Language Support to work and can't.
I've followed the instructions in the DBA Guide, i.e. I added

nls_sort = true
germany_germany.WE8HP

to init.ora.  Am I using the wrong character set?
Can anyone help?  

Thanks!
Karen
Newsgroups: comp.databases.oracle
From: cmdpjh@pmvax.weeg.uiowa.edu (Health Registry)
Subject: Paradox & Oracle
News-Software: VAX/VMS VNEWS 1.41    
Organization: University of Iowa, Iowa City, IA, USA
Date: Tue, 21 Jul 1992 21:57:00 GMT

We are running Oracle on a VMS platform (among others), and have a 
growing number of Paradox users on our Novell LAN.  I was wondering
if there is a way to 'transparently' use Oracle tables from within
Paradox.  We can support Novell, Pathworks, and TCP/IP, but would
like to keep it as simple as possible.

Any info would be useful.

Thanks,
Paul Henning

Dept. Preventive Medicine and Environmental Health
The University of Iowa

Newsgroups: comp.databases.oracle
From: lwv26@cas.org (Larry W. Virden)
Subject: Re: FAQ?  Defining a query page against multiple field/multiple table
Followup-To: comp.databases.oracle
Reply-To: lvirden@cas.org (Larry W. Virden)
Organization: Nedriv Software and Shoe Shiners, Uninc.
Date: Wed, 29 Jul 1992 17:22:19 GMT

In article <1992Jul28.132643.24259@cas.org> lvirden@cas.org (Larry W. Virden) writes:
:
:1. I have never seen a comprehensive FAQ posted to this group - is one
:available?

Well, I got one answer - that so far one has not evolved.  Too bad...

:
:Goal, not only to permit entry of the above information, but to allow
:the user to query against any combination of Name, Employee number, 
:Activity description and total hours. 
:
:Where does one start to permit the above query?  The problem is that I do NOT

Well, the overwhelming recommendation (thanks to the 2 people who responded)
was that I should define a view consisting of the 3 different tables and
then switch the user to a form based on that view when the user pressed
the Enter Query key.

Now, for the next problem.  One of the two people who responded indicated that
if I based the block on a view, I would have to write all of the query code
myself - but then indicated that I would need to write insert, delete and
update triggers.

What I thought about doing was something like this:

When the Key-Enter Query trigger occurs, move the user to a new block
which contains the new fields which they can query on.  Then, in the post
query trigger, I need to somehow move the resulting query info back into
the original form.  Since one of the fields on the query block will be
the primary key of all the tables on the input screen, is there some way
I can copy the 'set' of queried values back to the other page so that it
appears to the user as if all of the records are available to them?


-- 
Larry W. Virden                 UUCP: osu-cis!chemabs!lvirden
Same Mbox: BITNET: lvirden@cas  INET: lvirden@cas.org
Personal: 674 Falls Place,   Reynoldsburg, OH 43068-1614
America Online: lvirden@aol.com
From: fams09@v7.vitro.com
Newsgroups: comp.databases.oracle
Subject: Re: Deleting Duplicates
Date: 24 Jul 92 08:59:12 -0500
Summary: duh
Keywords: dhooh
Organization: Vitro Corporation

In article <1992Jul23.091611.1@jaguar.uofs.edu>, littlec1@jaguar.uofs.edu (Chris Little) writes:
> In article <VN70NB1w165w@iowegia.uucp>, bob@iowegia.uucp (Bob Powers) writes:
>> How can I delete duplicate rows in a table using SQL*PLUS.  This is
>> an unindexed table and I would like to keep it that way.
> 
> I'm relatively new at the job, but I suspect you could create a similar
> table, do an INSERT SELECT UNIQUE from the old table to the new table,
> delete all rows from the old table, copy all rows from the new table
> to the old, and then drop the new one.  Maybe there's a better way.
> 
> Good Luck.
> 
> --
> Chris Little, Programmer/DBA
1)
select...
from abc
for update of..


2) delete from abc y
   where rowid > (select min(rowid)
                  from abc x
                  where y.key_col = x.key_col)
/
From: sjs@netcom.com (Stephen Schow)
Newsgroups: comp.databases.oracle
Subject: Using Views for BLOCKS?
Date: 23 Jul 92 17:16:42 GMT
Organization: Netcom - Online Communication Services  (408 241-9760 guest)

I have heard that SQL*FORMS performance is a little better if I create a 
view of a table and then base the form block on the view instead of 
directly on the table.

Anyone have any experience to know if this is true or not?

ALSO,

What if I created a view with a join and based a form on that view as
if it was just one table.  Would I be able to update records and would
Oracle automatically update both the master and the detail records in the
actual tables?

Thanks in advance
-- 
------------------------------------------------------------------
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: slindemn@usdsd1.DaytonOH.NCR.COM (Steve Lindeman)
Newsgroups: comp.databases.oracle
Subject: Moving ORACLE system tablespace datafiles
Date: 27 Jul 92 13:56:31 GMT
Reply-To: slindemn@usdsd1.DaytonOH.NCR.COM (Steve Lindeman)
Distribution: na
Organization: NCR USG Data Services Division


To: Any ORACLE V6 or V7 user
Subject: Moving a the datafiles associated with the system tablespace


Many people have posed the question how do I move a system tablespace
datafile.
If a DBA refers to the index of the version 6.0 database guide (Database
files renaming) he or she is directed to pages 16-14, G-2 and G-7.
The instructions provided on page 16-14 of the ORACLE version 6.0 database
guide gives very limited instructions for moving a datafile that is not  
part of the system tablespace.  The instructions on this page do not mention
that this command cannot be used to move a datafile that is part of the system
tablespace.  The instructions on pages G-2 and G-7 give two different methods 
to rename a datafile but do not provide any furthur guidence.  These pages do
not make any reference to the fact that different methods must be used if
a system datafile is to be renamed.  

STEPS TO MOVE A SYSTEM TABLESPACE DATAFILE:

 1. The database must be mounted but not opened.
 2. The file must be copied to it's new location using an operating system
        command.  
 3. Connect internal.
 4. The alter database command must be used to rename the datafile.
 5. Shut the database down.
 6. Restart the database.
 7. Remove the old file once you are certain that the new file name is being
        used by the database.  Check the data dictionary table
sys.dba_data_files
        to determine if the new file is being used.


-- 
Stephen A. Lindeman              E-mail:Steve.A.Lindeman@DaytonOH.NCR.COM 
Data Services Division           Phone: (513) 445-3688
USG DSD Systems Architecture     Fax:   (513) 445-4176
Newsgroups: comp.databases.oracle
From: kjou@us.oracle.com (Kathy Jou)
Subject: Re: DB file not in DBA_DATA_FILES - problem
Followup-To: kjou@oracle.com
Organization: Oracle Corporation, Redwood Shores CA 94065
Date: Wed, 22 Jul 1992 18:08:53 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 <1992Jul21.112252.1@jaguar.uofs.edu> littlec1@jaguar.uofs.edu (Chris Little) writes:
>
>Major problem!!  While adding a database file to a tablespace, my main
>process died.  Now upon recovery I see that the DBWR process is
>accessing that file, but that file's description is not in DBA_DATA_FILES.
>Also, I doubt the DBWR is writing to it because I HAD to add another file
>in order to continue extending the database, which is what I was doing
>in the first place.
>
>Any suggestions?
>
>--
>Chris Little, Programmer/DBA
>                                                University Computing Systems
>                                                University of Scranton
>  LITTLEC1@JAGUAR.UOFS.EDU                      Scranton, PA 18510

I would venture to guess that something is inconsistent in the data dictionary.
If it is at all possible, then the safest action is to recreate the tablespace 
from an export of the objects that currently reside in it.  Does the control 
file still recognize this datafile?  How did you determine that DBWR is 
accessing that datafile which was not successfully added?  Did you perform
the add datafile operation again, using the same datafile name?  If the 
controlfile and dba_data_files match, then things should be OK.


Kathy Jou
Oracle Corporation
From: rick@rick.cs.man.ac.uk (Rick Dipper)
Newsgroups: comp.databases.oracle
Subject: Re: Deleting Duplicates
Date: 27 Jul 92 14:42:28 GMT
Reply-To: rick@uk.ac.man.cs
Organization: University of Manchester, Dept. Computer Science

In article <1992Jul23.091611.1@jaguar.uofs.edu>, littlec1@jaguar.uofs.edu (Chris Little) writes:
|> In article <VN70NB1w165w@iowegia.uucp>, bob@iowegia.uucp (Bob Powers) writes:
|> > How can I delete duplicate rows in a table using SQL*PLUS.  This is
|> > an unindexed table and I would like to keep it that way.
|> 
|> I'm relatively new at the job, but I suspect you could create a similar
|> table, do an INSERT SELECT UNIQUE from the old table to the new table,
|> delete all rows from the old table, copy all rows from the new table
|> to the old, and then drop the new one.  Maybe there's a better way.
|> 
|> Good Luck.
|> 
|> --
|> Chris Little, Programmer/DBA
|>                                                 University Computing Systems
|>                                                 University of Scranton
|>   LITTLEC1@JAGUAR.UOFS.EDU                      Scranton, PA 18510

My first guess, but it can fail.
	you need to do "create table <b> as select distince from <a>;"
		       "delete * from <a>;"
		       "insert into <a> select * from <a>;"

or use one of the row deleting queies in one of the messages of this newsgroup.


-- 
RICK DIPPER, Unix Systems Administrator                       rick@uk.ac.man.cs
Department of Computer Science, University of Manchester           061-275-5725
.............................Meemberrr the of Fumblee Ingers Culb..............
From: jaakola@cc.helsinki.fi
Newsgroups: comp.databases.oracle
Subject: Re: How to auto-start the field editor...
Date: 24 Jul 92 06:44:41 GMT
Organization: University of Helsinki

In article <1992Jul23.183451.29875@unixg.ubc.ca>, george@unixg.ubc.ca (George chow) writes:
> (I'm using Forms 3.) I've been trying to get the Field Editor to start up
> automatically upon entry of one of my fields. I've tried calling the 
> packaged procedure EDIT_FIELD in both KEY-NXTFLD and PRE-FIELD triggers and
> neither of them works. My situation is like this:
> 
>   FIELD         SEQ NO
>   Building_Code   3
>   Address         4
> 
> I attached the KEY-NXTFLD trigger to Building_Code but even with a go_field,
> I get stuck editing the Building_Code field. With the PRE-FIELD trigger,
Really? According to my intuition, it should work... the go_field was
before the EDIT_FIELD, wasn't it? What says the manual?

> I can a run-time error of:
> 
>   FRM-40737: Illegal restricted procedure EDIT_FIELD in PRE-FIELD trigger.
> 
> I've gone through all the triggers and I can't see which other triggers I can
> use to auto-start the field editor. Is this possible? Thanks for any help.
Look at the ON-NEW-FIELD-INSTANCE.
--
Juhani Jaakola
jaakola@cc.helsinki.fi
Xref: sparky comp.databases.oracle:1166 comp.databases:5836 alt.books.technical:205 misc.books.technical:1236 alt.books.reviews:32