HDTenEightyP/NetNews huggingface dataset:
From: mishra@hagar.bms.com (NARENDRA MISHRA)
Subject: How Good are PowerBulder, SQL Windows etc...
News-Software: VAX/VMS VNEWS 1.4-b1  
Organization: Bristol Myers Squibb Pharmaceutical Research Institute
Date: Fri, 8 Jan 1993 17:47:00 GMT


Hi Netters,

   We are Looking into application development Tools like PowerBuilder,
SQLWindows etc. to develop applications against ORACLE database. We would like
to get some input regarding capabilities, limitations etc. of such packages from
developers who have used them. Specifically we are looking for

   i) Ease of application Development
  ii) Reliability and Robustness of the products
 iii) Technical Support available from PowerSoft, Guptas etc.
  iv) Ability to aceess databases over SQL*Net ( using TCP/IP )
   v) Capabilities to produce Graphic output ( like drawing graphs, Charts
      etc.)
  vi) Any other critical features you may think of.
 vii) Do they Support ORACLE 7.0 and 6.0 ?  
viii) Performance of Applications Developed

Please post the replies over the Network or E-Mail to

   mishra@lavc01.bms.com

I will summarize the responses. 


Thanks

Narendra Mishra

Newsgroups: comp.databases.oracle
From: chau@ift.ulaval.ca (Nam Chau)
Subject: SQL
Reply-To: chau@ift.ulaval.ca
Organization: Dept. Informatique, Universite Laval
Date: Mon, 4 Jan 1993 22:27:00 GMT

Can anyone tell me where to find the code source of SQL.

Thansk!

Nam Chau
Email: chau@ift.ulaval.ca


Newsgroups: comp.databases.oracle
From: blah@maas-neotek.arc.nasa.gov (MJW/TWF)
Subject: Re: 40 values in desc order
Organization: NASA Ames Research Center
Date: Fri, 8 Jan 1993 21:29:42 GMT

In article <1993Jan8.200238.534@osnbe.Olivetti.ch> rheiger@renext.eiger.olivetti.ch writes:
>In article <6622.2b485a61@hayes.com> fgreene@hayes.com writes:
>> In article <Bzo2t0.67@lut.fi>, hietanen@lut.fi (Pentti Hietanen) writes:
>> > 
>> > What kind of sql sentence should we use to get 40 values
>> > from database in descending order?
>> > 
>> > Pentti Hietanen, student of Lappeenranta University of Technology, Finland.
>> > internet: hietanen%lut.fi
>> 
>> 
>> Probably the easiest way is to use the ROWNUM function.  For example,
>> 
>> 	SELECT field1, field2, fieldn
>> 	FROM   the_table
>> 	WHERE  ROWNUM < 40;
>> 
>This will only limit the output to the first 40 rows. It will not order them in  
>a predictible manner. If you want to order the rows descending you should  
>probably use the "ORDER BY attr1, attr2... DESCENDING" clause. However this  
>will not restrict the select to 40 rows. To do both you could
>
>select <attribute1>,....
>from tablename
>where key_attr_list in (
>select key_attr_list
>from tablename
>order by order_attr_list descending)
>where rownum < 40;
>
>This is probably rather SLOW. I am sure some SQL cracks will have a better  
>solution.

Unfortunately, it won't even work, as you have an ORDER BY in a
subquery, which is a nono.

There is no way to limit the number of rows selected, and use an ORDER
BY, in the same SQL statement.  This is because the ROWNUM value is
assigned before the rows are ordered by the ORDER BY clause.  

Note that, using a view, what you want to accomplish is not difficult
at all.

Mark
Newsgroups: comp.databases.oracle
From: bruno@bc3.GUN.de (Bruno Cirone)
Subject: running total (SQL query)
Organization: private
Date: Tue, 12 Jan 1993 18:39:53 GMT
X-Newsreader: TIN [version 1.1 PL6]

I have this table:

	Name	      Score

	Werner		200
	Hugo	       -100
	Heinz		300
	Bruno		100

I want this table to be printed like the following:

	Name	      Score	total

	Werner		200	200
	Hugo	       -100	100
	Heinz		300	400
	Bruno		100	500

How can I do that with Oracle (without report-generator) ?

-- 
Bruno Cirone 			InterNet: <bruno@bc3.gun.de>
Theodor-Heuss-Ring 19-21	UUCP: ...!unido!easix!flyer!bc3!bruno
5000 Koeln (Cologne) 1		Fax : +49-221-7710931
FRG / Germany			Tel.: +49-221-7710929
From: bogreen@unixg.ubc.ca (Bo Green)
Newsgroups: comp.databases.oracle
Subject: Export/Import to tape?
Date: 11 Jan 93 17:52:07 GMT
Organization: The University of British Columbia
NNTP-Posting-Host: unixg.ubc.ca


 1) I need to change the tablespace allocation of a large database I am
 working with, so I thought the best way would be to Export, create
 new tablespaces, and then Import the tables. Unfortunately, I don't
 have enough disk space to Export to disk. I figure out how I can Export
 to exabyte tape in a reasonably efficient way. Any ideas?

 2) If I use "COMMIT=Y" on an Import, will that solve the problem of a 
 lack of enough rollback space for a large table?


 Thanks for any help.

 Bo Green
 Centre for Health Services
 University of BC
 Vancouver, Canada
From: dtg@wvnvms.wvnet.edu
Newsgroups: comp.databases.oracle
Subject: Oracle FAQ???
Date: 4 Jan 93 15:23:18 GMT
Organization: West Virginia Network for Educational Telecomputing

Is there an ORACLE FAQ list or compilation of ORACLE info which would be
FAQ-like material available through anonymous FTP???

Please send replies to:
grasso@cards.com

Thank you for your time.
dave
Newsgroups: comp.databases.oracle
From: andy@homebase.vistachrome.com (Andy Finkenstadt)
Subject: Re: Oracle and SUN Solaris 2 
Reply-To: andy@homebase.vistachrome.com
Organization: Vista-Chrome Incorporated
Date: Fri, 8 Jan 1993 14:58:24 GMT

bourasse@cicb.fr (Claude Bourasseau - CICB Rennes 99.84.71.24) writes:
>We use ORACLE RDBMS 6.0.33 on several Suns under SunOS 4.1.1 or SunOS 4.1.2.
>SUN announces its new OS : SOLARIS 2; What about ORACLE under this new
>major release ?
>Thanks in advance.
>-- 
>---------------------------------------------------------------------------
>Claude Bourasseau      CICB Campus de Beaulieu   35042 Rennes Cedex  FRANCE
>Tel: +33 99 84 71 24   Fax: +33 99 84 71 11      E-mail: bourasse@cicb.fr

According to Oracle Worldwide Support at the end of December,
Oracle version 6 for the Sun is not certified to run on Solaris
2.0 or 2.1.

Sigh.

-- 
Andrew Finkenstadt, Vista-Chrome, Inc., Homes & Land Publishing Corporation
GEnie Unix RoundTable Manager, andy@vistachrome.com, andy@genie.geis.com.

"[The author] neither accidentally nor intentionally omits or includes 
anything that could support a preconceived thesis." - C&EN 21-DEC-92 p.72
Newsgroups: comp.databases.oracle
From: sjs@netcom.com (Stephen Schow)
Subject: Re: How to keep version number inside *.frm ?
Organization: Netcom - Online Communication Services  (408 241-9760 guest) 
Date: Fri, 8 Jan 1993 19:00:21 GMT

I use RCS also.  You can simply put the RCS string in the form comment field
or in the inp file as a variable assignment.  I had not thought of putting
it in the TITLE field.  This would possibly have the effect of putting 
a cryptic looking title just below the menu bar when you run the form in
popup mode or one of the GUI platforms.

I put $Revision$ and $Source$ in the comment field of the form and then
I also use a header block which include several display only fields, such
as UserID, Date, Version, etc...

By assiging a global variable the RCS string, and then running a PL/SQL
procedure that extracts just the wanted portion of that RCS string and putting
that into the header block display only field.  What you end up with is 
a nice little "Version X.XX" at the top of the screen.

I'm not really sure how it looks in the frm file.  WHen you check the inp
file in and out of RCS, it updates the RCS strings and then you must
generate that inp file to create and frm file.  I suppose it is possible
that it retains the string format enough that you could use the equivlent
of 'what' on the frm.  (RCS doesn't use 'what', it uses something else
that I can't remember its name right now).

Hope this helped
-- 
------------------------------------------------------------------
Steve Schow    | But you don't have to use the claw, if you
sjs@netcom.com | pick the pear with the big paw paw......
(415) 354-4908 | Have I given you a clue......?
               |                       - Baloo the Bear
------------------------------------------------------------------
From: rcivan@rwb.urc.tue.nl (Ivan Saez)
Newsgroups: comp.databases.oracle
Subject: Oracle on DEC Alpha
Keywords: Alpha
Date: 11 Jan 93 11:30:16 GMT
Reply-To: rcivan@urc.tue.nl

Hi,

 Is there anyone using Oracle on Alpha systems? If so then I have a two 
questions: 
             - which version is it ? (Is it a beta release?)
             - how is the performance ?
               (Does Oracle benefit from the increased CPU performance)

Thanks,

              Ivan

----
Ivan Saez Scheihing , Eindhoven University of Technology
Computing Centre 1.62,  +31 40 474428
P.O.Box 513, 5600 MB Eindhoven, The Netherlands
E-Mail: rcivan@urc.tue.nl
-- 
Ivan Saez Scheihing , Eindhoven University of Technology
Computing Centre 1.62,  +31 40 474428
P.O.Box 513, 5600 MB Eindhoven, The Netherlands
E-Mail: rcivan@urc.tue.nl
From: guy@mais.hydro.qc.ca (Guy Harel)
Newsgroups: comp.databases.oracle
Subject: Re: switch from one instance to another
Date: 8 Jan 93 15:56:43 GMT
Organization: Hydro-Quebec (DSB)

steiger@rzu.unizh.ch (Steiger Daniel) writes:

>Dear dba`s

>recently I have created an additional instance, so that I have two databases 
>sharing the same kernel. 

I you really have 2 instances, then they should have their own 'kernel',
if by kernel you mean the SGA.


>Question 1: How can I switch from database 1 to database 2 as dba and as
>            ordinary user?  

Just change the value of your variable ORACLE_SID

>Question 2: is it possible to run both databases at the same time ?

Yes
-- 
--
From: dbenua@panix.com (David Benua)
Newsgroups: comp.databases.oracle
Subject: Re: VISUAL BASIC AND QELIB
Date: 5 Jan 93 02:44:50 GMT
Organization: PANIX Public Access Unix, NYC

In <524.204.uupcb@sqlware.uunet.UU.NET> joe.bartling@sqlware.uunet.UU.NET (Joe Bartling)  writes:


>I have been using Visual Basic under MS-Windows and connecting to ORACLE
>using QELib from Pioneer Software which connects to Oracle via SQL*Net.
>The biggest problem is that I can't connect to a local DOS ORACLE
>database (only client-server).  Other than waiting for Pioneer to come
>out supporting local an Oracle DOS database, are there any other
>solutions given my front-end of Visual Basic?  Has anyone heard of
>Microsoft Access?  Will that help?

MS Access uses ODBC to get the data, so you need a driver which supports
Oracle on DOS. As far as I know the SQL*Net driver isn't out yet, so
I expect the answer is "No, it won't help"

Dave B.
dbenua@panix.com
From: zhou@igd.fhg.de (Zhou Jian)
Newsgroups: comp.databases.oracle
Subject: How to install SQL*Forms -- Help needed!
Date: 4 Jan 93 10:57:18 GMT

Dear netters,

Happy New Year!

I am installing SQLFORMS on a SUN-SPARC/SLC, using  SunOS Release
4.1.1 and X11R5.  I used the utility crt and created the file
XTERM.crt. However, when I call sqlforms to run examples in the
SQL*Forms Designer's Tutorial, sqlforms hangs up after I input userid
and password.

Can anyone give me some tips on how to install SQL*Forms under X11(mwm
window is used)? PLease send your suggestions to 
	zhou@igd.fhg.de
I use Oracle RDBMS  V6.0.33.1.1 and SQL*Forms 2.3.31.1.4.

Thank you in advance.

+----------------------------------------------------------------+
| Jian Zhou -- Jaegertorstr. 41 -- 6100 Darmstadt 12 -- Germany  |
| email: zhou@igd.fhg.de                Home:   +49/6151/377537  |
| Fax: +49/6151/155199                  Office: +49/6151/155141  |
+----------------------------------------------------------------+

P.S. When I installed the whole oracle rdbmsseveral months ago, I used
oracle.install to install the SQL*Forms. oracle.install automatically
selected sun-cmd as default terminal and created the file SUN-CMD.crt.
My SQL*Forms  currently works well under openwindow, but not under
X11R5/mwm.
From: jlove@ivrit.ra.itd.umich.edu (Jack Love)
Newsgroups: comp.databases.oracle
Subject: Re: Oracle Card v.s. SQL*FORMS 4.0
Date: 6 Jan 1993 22:00:16 GMT
Organization: /usr/local/trn/lib/organization
NNTP-Posting-Host: ivrit.ra.itd.umich.edu

In article <C0GB3B.KzB@zoo.toronto.edu> sonya@zoo.toronto.edu (Sonya Neufer) writes:
>Does anybody know when the next version of Oracle Card and SQL*FORMS
>4.0 is to be released?  

Oracle is not commenting on the release of Forms 4. The question 
with respect to Oracle*Card is what release are you referring to?
There has already been a significant enhancement to the MS-DOS
(Windows) version of Oracle*Card which resulted in a significant
increase in price--I believe this is version 1.1. I haven't yet
heard when the equivalent product will be released for Mac.

>Since SQL*FORMS 4.0 is going to be a Windows
>Application what is the difference between it and Oracle Card?

Different animals. SQL*Forms is a traditional electronic data input
program which emphasizes rapid application development for data
input operators with a high degree of data integrity. It is an 
incremental improvement over Forms 3 adding integrated menus, 
greater GUI compatibility and even some use of effects such as
graphics and sound. Oracle*Card is also an application development
tool, but it is based on the Hypercard metaphor. It has built-
in reporting capabilities that are not yet implemented for 
SQL*Forms, but the reports are pretty rudimentary. It has very
little in the way of automatic data validation so I find that
application development is much slower. Performance is sluggish,
at least compared to SQL*Forms under DOS or Unix. It is often
possible to create feature-rich applications with SQL*Forms
with little or no resort to 3GL's, but everyone I know who has
developed with Oracle*Card has had to do at least some 3GL
programming. A lot of people think that Oracle*Card is more
"fun." SQL*Forms is a boring "mainframish" environment.
-- 
________________________________________
Jack F. Love	| 	Opinions expressed are mine alone.
		|	(Unless you happen to agree.)
From: msweetes@axion.bt.co.uk (Michael Escott)
Newsgroups: comp.databases.oracle
Subject: Help : Oracle Graphics Packages
Date: 12 Jan 93 10:21:41 GMT
Reply-To: msweetes@axion.bt.co.uk (Michael Escott)
Organization: British Telecom Research Labs


Hi,

I'm currently using Oracle*Graphics to produce numerous and
varied amount of Graphs from an Oracle database (v.6+).I find the
SQL access to the database a great feature of this system,however 
I need far mode flexability/functionality from the package.

Could anyone tell me about any *robust* graphing products out there
that has SQL access to tables (prefeably from more than one database 
at the same time) and which also has some of the functionality of
spreadsheets once the data is extracted from the database.  

If any one is using such a product could they please send their 
views to me. 

P.S.: I'm using a UNIX server and therfore the product should preferably
work under the UNIX O/S.

Thanks in advance,
		Michael Escott.













=========================================================================
Disclaimer : "The views above are in no way related to those of BT, but
are personal to me." 	Michael Escott
=========================================================================
Newsgroups: comp.databases.oracle
From: rheiger@renext.eiger.olivetti.ch (Richard H. E. Eiger)
Subject: Re: 40 values in desc order
Reply-To: rheiger@renext.eiger.olivetti.ch
Organization: Olivetti (Schweiz) AG, Branch Office Berne
Date: Fri, 8 Jan 1993 20:02:38 GMT

In article <6622.2b485a61@hayes.com> fgreene@hayes.com writes:
> In article <Bzo2t0.67@lut.fi>, hietanen@lut.fi (Pentti Hietanen) writes:
> > 
> > What kind of sql sentence should we use to get 40 values
> > from database in descending order?
> > 
> > Pentti Hietanen, student of Lappeenranta University of Technology, Finland.
> > internet: hietanen%lut.fi
> 
> 
> Probably the easiest way is to use the ROWNUM function.  For example,
> 
> 	SELECT field1, field2, fieldn
> 	FROM   the_table
> 	WHERE  ROWNUM < 40;
> 
This will only limit the output to the first 40 rows. It will not order them in  
a predictible manner. If you want to order the rows descending you should  
probably use the "ORDER BY attr1, attr2... DESCENDING" clause. However this  
will not restrict the select to 40 rows. To do both you could

select <attribute1>,....
from tablename
where key_attr_list in (
select key_attr_list
from tablename
order by order_attr_list descending)
where rownum < 40;

This is probably rather SLOW. I am sure some SQL cracks will have a better  
solution.

--
                         
    ___           _____2
   /   )  /  /   /        Richard H. E. Eiger
  /_ _/  /__/   /__       Ing. Informatik HTL
 /\     /  /   /          Unregistered NeXT fan
/  \   /  /   /_____      rheiger@renext.eiger.olivetti.ch (NeXT mail welcome)
Newsgroups: comp.databases.oracle
From: ttabet@currie.tansu.com.au (Tabet Tabet)
Subject: Updating 2 database tables from one Block				
Reply-To: ttabet@currie.tansu.com.au
Organization: AOTC - CSSC
Date: Mon, 11 Jan 1993 00:48:51 GMT

Hi folks,

I want to update 2 database  tables using one block. I am using Oracle forms Ver.2.3

Is there anyone who has a practical answer of how to do that ?

Appreciate your help.

Tabet.
From: fgreene@hayes.com
Newsgroups: comp.databases.oracle
Subject: Re: MULTIPLE LIST OF VALUES
Date: 12 Jan 93 08:21:04 EDT
Distribution: world
Organization: Hayes Microcomputer Products, Norcross, GA

In article <811.204.uupcb@sqlware.uunet.UU.NET>, mike.sullivan@sqlware.uunet.UU.NET (Mike Sullivan)  writes:
> I am running Oracle 6.0.34 on Interactive Unix w/ Sqlforms 3.0 and have
> a question on how to do the following:
> 
> When a user enters a field, I'd like a list of values to appear. They
> can scroll up and down the list and by hitting a key, select that item
> (maybe going reverse video to show a selection), and then go on to
> select another item. After choosing one or more items, they hit a key
> and progress to the next field on the form. They can circle back to the
> field w/ the LOV, with their previous selections in reverse video
> (or whatever). When they are done with the present form, they hit Enter
> Query to retrieve the records that matched the values set in the
> multiple LOV as well as any other fields on the form.
> 
> Any suggestions.

Use a KEY-NXTFLD trigger on the PREVIOUS field to navigate to a pop-up
window and execute a query, as in

	GO_FIELD('the_list');
	EXECUTE_QUERY;

The pop-up window is actually a separate block that contains the list
of values you are seeking along with a dummy field.  The actual values
are display only (assuming you don't want to change anything).  Thedummy
field (the_list) allows the screen to display.

Any retrieval limitations, sorting criteria, etc., are included in the
block definitions for the list block.  

Navigate in the block normally using arrow keys.  Highlighting can be 
controlled with the SET_FIELD parameter.

Exit control is done with a KEY-NXTFLD trigger attached to the field
'the_list'.  Transfer your selected parameter back to the target field and
then jump to the next field as in

	:block.target_field := :block_list.the_list;
	GO_FIELD('block_whatever.the_next_field')

 ----------------------------------------------------------------------------
 |      Frank Greene                  |          //////  //////             |
 |      DELPHI SYSTEMS, Inc.          |           ////    ////              |
 |      Telephone [615] 458-6032      |          ////    ////  //////       |
 |      Compuserve 74200,427          |         ////    ////    ////        |
 |      324 Ootsima Way               |        ////    ////    ////         |
 |      Loudon, TN 37774              |       //////  //////  //////        |
 ----------------------------------------------------------------------------
 |         Of course, any opinions or suggestions are strictly my own       |
 ----------------------------------------------------------------------------
Newsgroups: comp.databases.oracle
From: stillson@mitre.org (Ken Stillson)
Subject: Re: SQL Net
Organization: The MITRE Corporation
Date: Mon, 11 Jan 1993 15:16:39 GMT

In comp.databases.oracle you write:

>We looking at using Oracle in a distributed environment. I've heard that
>this is accomplished using SQL net. But is it reliable? Is it a good product? 
>Is it worth it.  Are there any alternatives?

  Well, we've installed it, but aren't making much use of it, because it's
  not a very good product(s), and not very reliable...  We have Oracle
  running on a Sun 4, connected to a PC with a Western Digital ethernet
  card, and running Windows 3.1.  The idea was to use Q+E (an Excel add in
  that understands SQL*Net) to allow SQL queries from inside Excel to go to
  the server.

  Okay, here's the data chain: SQL*Net (for the PC by Oracle) uses TCP/IP,
  and requires one of four obscure versions of TCP/IP: all of which are
  incompatible with our currentl IPX [Novell] / Packet Driver ethernet
  system.  We chose the 3Com version of TCP/IP, and had to obtain a patch
  for the 3com software to work with the WD hardware (and it was still a
  pain!)..  After that you have to add window's patch's to get the channel
  though windows...  and though everything you need qemm to run your
  memory...  So we're tring to get a system working with stuff fro 6
  different vendors: QuarterDeck (qemm), 3Com (tcp/ip), GTSI (patch to 3com
  for WD), Oracle (sql*net, sql*tcp, and sqlwin.dll), Pioneer (Q+E), and
  MicroSoft (Excel).  Let me tell you-- it's a pain.

  After two weeks fussing (and dozens of calls to all of the above vendors)
  with memory conflicts, IRQ link bugs, obscure protocol files, out of date
  DLL's, new versions, newer versions, re-arranging interrupts, tracing
  things though assembly language to see where they crashed-- we finally
  got it working.

  However, you basically have to dedicate your machine to it: it doesn't
  work with telnet or Novell, takes so much memory windows is crippled, and
  is slow enough that it's generally easier to do the query in SQL on the
  sun, use emacs to convert it to csv, and ftp it over.

  I don't know what those others who responded saying the system was okay
  were doing-- but I found the whole thing a techno-nightmare, and informed
  my management that while the technology made it possible, the
  software just isn't ready yet.

	- Ken Stillson, stillson@mitre.org

--
                                                                ____
panic: cannot read .signature file for stillson@mitre.org       \  /
Abort, Retry, Ignore, Explode?                                   \/
Newsgroups: comp.databases.oracle
From: Neil Greene <neil@kynug.org>
Subject: Long raw data types
Reply-To: Neil Greene <neil@kynug.org>
Organization: University Of Kentucky, Dept. of Math Sciences
Date: Mon, 11 Jan 1993 00:12:30 GMT

When storing images in Oracle, fields must be defined as LONG RAW,  
correct??  Isn't there a table limitation as to the number of LONG RAW  
datatypes allowed?

--
Neil Greene 
benchMark Developments, Inc. [NeXT VAR]
Kentucky NeXT User Group, Inc.
neil@kynug.org