FAQ

Oracle > oracle-l > March 1995

Search Discussions

99 discussions - 182 posts

  • : TO_CHAR info deleted : I am active on a few mail lists and most of them use the list id as the from id ... only one list sends "from" the posting user. We had an on-line debate about this issue on ...
    Steve Calvert Ext. 2071Steve Calvert Ext. 2071
    Mar 13, 1995 at 11:46 am
    Mar 16, 1995 at 3:05 pm
  • Greetings, We have a client that insists on raw devices for a large DB we are helping them implement. Having always been File I/O oriented we are not sure of the benefits/drawbacks. Anyone have a ...
    Eclipse Technology Inc.Eclipse Technology Inc.
    Mar 13, 1995 at 8:17 pm
    Mar 20, 1995 at 7:17 am
  • Hi You can get procedure, function, and package names from SELECT DISTINCT NAME FROM ALL_SOURCE ORDER BY 1; But what is FORM_PROCEDURE ??? MN Dept of Health, Enviromental Health Division Internet ...
    Allen WellsAllen Wells
    Mar 11, 1995 at 7:44 pm
    Mar 19, 1995 at 6:07 pm
  • When compiling with Pro*C: Release 2.0.4.0.0 with Oracle 7.1.4.1/SunOs 4.1.3) I get the following error: ld: Undefined symbol _sqlcex I looked through all the provided libraries (buy "ar t") but I ...
    Farzin ShakibanejadFarzin Shakibanejad
    Mar 14, 1995 at 2:37 am
    Mar 20, 1995 at 6:56 am
  • Hi I know that it's possible to find out how a view was created by looking at the text field of table user_views. I was wondering if there is a similar way to determine how tables were created, that ...
    Dave HenleyDave Henley
    Mar 16, 1995 at 12:02 pm
    Mar 19, 1995 at 6:41 pm
  • Does anyone know how I might reach the vendor or sales rep for; Andyne BrioQuery Cognos Esperant reporting tools? Thank You! David Niccoli niccoli_at_uscolo.edu
    DAVID NICCOLIDAVID NICCOLI
    Mar 16, 1995 at 1:11 pm
    Mar 19, 1995 at 7:14 pm
  • Hello everyone, Env: Sun Os 4.1.3, Oracle 7.1.3 I've seen this thread before, but haven't found a solution to satify my needs. So here it is again - how do I make trace files readable by the public, ...
    Leng KaingLeng Kaing
    Mar 12, 1995 at 10:37 pm
    Mar 13, 1995 at 8:33 pm
  • Hello, up to ORACLE V6 there was only a variable-length string datatype (CHAR). Now there is VARCHAR2 and CHAR. For known fixed-length values this might be an improvement in disk usage. On the other ...
    Reinhold BroekerReinhold Broeker
    Mar 13, 1995 at 7:42 pm
    Mar 19, 1995 at 6:41 pm
  • Greetings, We are a VMS site running Oracle V7 and are looking for DBA tools. We have found several excellant products but unfortunately they do not run under VMS. The one exception so far is BMC ...
    George CurtisGeorge Curtis
    Mar 14, 1995 at 1:32 pm
    Mar 19, 1995 at 4:22 pm
  • It seems that no one around here uses create package, which probably sounds strange to most of you. However, I decided to try it and get the following messages: Warning: Package created with ...
    John CarlsonJohn Carlson
    Mar 13, 1995 at 5:25 pm
    Mar 14, 1995 at 4:52 pm
  • We are not new to Oracle, but our site is very new to PC's. Our internal customers want to use their Microsoft Query tool to access Oracle data. Do we need SQL*Net on the PC clients? Can a PC client ...
    Denise M. KellyDenise M. Kelly
    Mar 16, 1995 at 3:52 pm
    Mar 19, 1995 at 7:13 pm
  • I am writing some PL/SQL procedures that use the DBMS_OUTPUT package. These procedures use an outer join cursor and some brute force to compare the column values of corresponding rows in identically ...
    Rick WigginsRick Wiggins
    Mar 16, 1995 at 12:02 pm
    Mar 19, 1995 at 6:41 pm
  • Hello Oracle prophets: I am using forms3 (key trigger) and need to search through LONGS to find certain strings. Since LONGS cannot be used in the usual string functions, I am considering various ...
    Systems EngineeringSystems Engineering
    Mar 16, 1995 at 12:28 pm
    Mar 19, 1995 at 6:07 pm
  • Hi all, I am sort of a "Newbie" to the list. I have been a quiet observer for some time now and I've come across a real frustration. I will genuinely appreciate any advice you can give. I have a huge ...
    Will Weir, SICAS CenterWill Weir, SICAS Center
    Mar 16, 1995 at 2:36 pm
    Mar 19, 1995 at 5:39 pm
  • �����Hi everyone, We are currently searching for a DBA tool that we can run under Windows 3.1 and/or OS/2 to monitor and update databases running on a UNIX RS6000. Presently we are evaluating ...
    McGrath, LisaMcGrath, Lisa
    Mar 16, 1995 at 1:53 pm
    Mar 16, 1995 at 7:10 pm
  • in MENUTABS.SQL is there a commando SET COMPABILITY V6 and in V6 char is variable length - so therefore it creates a var-length ( VARCHAR2 in V7). Kurt S Jensen DSB data - Denmark.
    Kurt Strandby JensenKurt Strandby Jensen
    Mar 14, 1995 at 7:20 am
    Mar 16, 1995 at 4:37 pm
  • Could someone please remind me when papers are due for the Oracle conference in Philadelphia?
    GLENN CARLSTROMGLENN CARLSTROM
    Mar 14, 1995 at 9:02 am
    Mar 14, 1995 at 5:28 pm
  • �����Dear Nirmalya, I am responding to your question about DB-VISION. DB-VISION is one of a number of products that perform database monitoring and tuning. Eventus, a MITI subsidiary, also produces a ...
    Jim CollingsJim Collings
    Mar 13, 1995 at 9:05 pm
    Mar 14, 1995 at 11:42 am
  • Greetings! I am currently working on a form which will allow users to display text documents (stored as LONG) in a databse table. Is there a way to do this and make the document look O.K? i have been ...
    Mike NavarroMike Navarro
    Mar 13, 1995 at 7:09 pm
    Mar 14, 1995 at 11:07 am
  • I have a table with 2 columns (descendant, ancestor) in which I have stored thesaurus data (narrower term, broader term). Now, I need to retrieve the hierarchy trees using ORACLE's "start ...
    Karen HuguleyKaren Huguley
    Mar 16, 1995 at 6:36 pm
    Mar 19, 1995 at 6:41 pm
  • I have written the following code to sum items that are from a specific purchase order number. This code does work, except for the very first time it executes each time the form is run. I do not know ...
    Tanya GeorgeTanya George
    Mar 16, 1995 at 6:36 pm
    Mar 19, 1995 at 4:57 pm
  • Call 205-830-9133, ask for Buff Emslie, She runs Bookstore for Oracle User Group. She should know. \\\|/// \\ ~ ~ // (/ @ @ /) ...
    Sunil GodithiSunil Godithi
    Mar 16, 1995 at 5:49 pm
    Mar 16, 1995 at 5:49 pm
  • Did someone take the thread about broadcasting to the list seriously? Or are we all just quiet today? Powel Crosley 6410539_at_mcimail.com
    Eclipse Technology Inc.Eclipse Technology Inc.
    Mar 16, 1995 at 11:37 am
    Mar 16, 1995 at 5:48 pm
  • Date: Thu, 1 Sep 1994 16:00:12 +0800 Reply-To: "ORACLE database mailing list." Sender: "ORACLE database mailing list." From: "Dennis Chan, 7888278" Organization: City Polytechnic of Hong Kong ...
    1.8a1.8a
    Mar 15, 1995 at 10:51 am
    Mar 16, 1995 at 5:46 pm
  • I find myself in a similar position, having received 10 messages within an hour of joining this list. The normal practice on other lists I have joined is to reply to the sender, who then posts a ...
    John WhistlerJohn Whistler
    Mar 14, 1995 at 10:48 am
    Mar 14, 1995 at 5:28 pm
  • I vote for replying to the list. At least half of the useful information I've gotten off this list has been from conversations between individuals. And I'm _sure_ that I don't have time to be ...
    Dennis ReedDennis Reed
    Mar 14, 1995 at 1:06 pm
    Mar 14, 1995 at 4:04 pm
  • From: EKEZUE, F. C. (FIDELIS) -FCEK To: OPEN ADDRESSING SERVI-OPENADDR Subject: ORACLE DATA BROWSER INSTALLATION Date: 1995-03-14 09:00 Priority: Hi, Does anyone out there have any experience ...
    EKEZUE, F. C. (FEKEZUE, F. C. (F
    Mar 14, 1995 at 5:02 am
    Mar 14, 1995 at 9:01 am
  • A buddy of mine has been unsuccessful attracting the number of Oracle experts he is attempting to hire for his shop in Cleveland. Any suggestions where to padvertise/post???? The positions are ...
    Christopher W. PritchardChristopher W. Pritchard
    Mar 13, 1995 at 9:05 pm
    Mar 14, 1995 at 7:46 am
  • �����If someone else already answered this I did not see it. The form_procedure table is a "data dictionary" table used by sql*forms30 to track stored sql*forms procedures. I am pretty sure it is ...
    Monty TompkinsMonty Tompkins
    Mar 13, 1995 at 1:08 pm
    Mar 13, 1995 at 4:04 pm
  • Is there a way for disabling logging of information while using SQL*loader to load data into the DB. Thanks in advance, Rajan
    Rajan GuptaRajan Gupta
    Mar 13, 1995 at 2:22 am
    Mar 13, 1995 at 10:03 am
  • 0

    PO7

    Can anyone please tell me if Personal Oracle 7 uses the standard Oracle V$.. dictionary tables? Are there many differences between the Personal version and the Unix version? Does the personal version ...
    Andy K. HorneAndy K. Horne
    Mar 20, 1995 at 9:08 am
    Mar 20, 1995 at 9:08 am
  • Dave Henley - The problem is that USER_SOURCE is not really a table, it is a view. The underlying table for that view is a data dictionary table owned by SYS. Exporting a user doesn't really export ...
    John C FlackJohn C Flack
    Mar 20, 1995 at 9:08 am
    Mar 20, 1995 at 9:08 am
  • Thanks to all who responded to my plea for advice. I came up with a solution on Friday with a little help. For those familiar with my select statement, all I had to do was get rid of the TRUNC ...
    Will Weir, SICAS CenterWill Weir, SICAS Center
    Mar 20, 1995 at 8:34 am
    Mar 20, 1995 at 8:34 am
  • 0-07-881182-1 -- * Mike Jackson * Reader in Software Engineering * School of Computing and Information Technology * University of Wolverhampton * Wulfruna St. Phone: +44 902 322194 * Wolverhampton ...
    Mike JacksonMike Jackson
    Mar 20, 1995 at 7:42 am
    Mar 20, 1995 at 7:42 am
  • ORACLE DBA Handbook by Kevin Loney is very useful. Prize $ 34,95 ISBN 0-07-881182-1 Hans Ackema Database Administrator Informatiseringscentrum | phone: +31-20-525 2735 Universiteit van Amsterdam | ...
    Hans AckemaHans Ackema
    Mar 20, 1995 at 7:42 am
    Mar 20, 1995 at 7:42 am
  • Hello everyone, As I wait for CASE5.1, and dare I hope CASE5.2, I have to deal with 5.0. I'm trying to set up a database for CASE5.0 users on Oracle 7.1.3 and SunOS 4.1.3. I believe that CASE5.0 was ...
    Leng KaingLeng Kaing
    Mar 19, 1995 at 11:19 pm
    Mar 19, 1995 at 11:19 pm
  • Hello all. Please respond directly to my email in the header if you have an idea for this one. Oracle7.0.12.2.0 on A/UX I created a table with several references column constraints. The referencing ...
    Alex SirotaAlex Sirota
    Mar 19, 1995 at 6:41 pm
    Mar 19, 1995 at 6:41 pm
  • Ravi et. al, I think that I've resolved my previous problem with trace files now. The way to make trace files accessible by the public is to have umask of those generating the trace files to 022. And ...
    Leng KaingLeng Kaing
    Mar 19, 1995 at 6:41 pm
    Mar 19, 1995 at 6:41 pm
  • Hi again, It seems that I have confused a lot of people, including myself, with my question about user's data dictionary tables. Let me give an example of what I'm trying to do : I want to use exp to ...
    Dave HenleyDave Henley
    Mar 19, 1995 at 6:41 pm
    Mar 19, 1995 at 6:41 pm
  • Hi Will, You were right, the TRUNC-function is the problem. You can solve this by using the BETWEEN-construction. Secondly, try to use as few tables as possible in a query. Tables wich have only one ...
    Martin de JongMartin de Jong
    Mar 19, 1995 at 6:40 pm
    Mar 19, 1995 at 6:40 pm
  • Hello Oraclites: As a recruiter, I am always finding new and challenging jobs for IT professionals like you. Since this list is subscribed to by Oracle IT professionals for an exchange of information ...
    Sam DobrowSam Dobrow
    Mar 19, 1995 at 6:07 pm
    Mar 19, 1995 at 6:07 pm
  • Hi Netters, I have an SQL*Plus script with "COMPUTE SUM OF INV_AMOUNT ON SOURC REPORT" The above statement is to have a subtotal break on source (field) and grand total at the end of the report. In ...
    Palani K RPalani K R
    Mar 19, 1995 at 6:07 pm
    Mar 19, 1995 at 6:07 pm
  • hi friends Please kindly give me the e-mail address of ORACLE FAQ(oracle frequently asked questions ) thank u in advanced bye chakku M.K.Chakravarthy * E-mail :chakra_at_wslvax1.wipsys.soft.net * ...
    Chakravarthy KalyanaChakravarthy Kalyana
    Mar 19, 1995 at 5:39 pm
    Mar 19, 1995 at 5:39 pm
  • Happy St. Patrick's Day to all!! I am currently trying to convert some Forms 3.0 forms to 4.5. Is this possible? I am using the SDK (Trial Offer) version of 4.5. When I try to convert, I get the ...
    Mike NavarroMike Navarro
    Mar 19, 1995 at 4:56 pm
    Mar 19, 1995 at 4:56 pm
  • Re: I have a table with 2 columns (descendant, ancestor) in which I have stored thesaurus data (narrower term, broader term). Now, I need to retrieve the hierarchy trees using ORACLE's "start ...
    DaustinDaustin
    Mar 19, 1995 at 4:56 pm
    Mar 19, 1995 at 4:56 pm
  • }]mCl#Please Confirm[{ Hello, Listers! I have a low level problem/question regarding SQL*Plus (3.0.11.1.1). Has anyone out there learned/developed/discovered away to sound a bell/beep in SQL*Plus? ...
    Jill ZeitlerJill Zeitler
    Mar 19, 1995 at 4:56 pm
    Mar 19, 1995 at 4:56 pm
  • When I have a form (window) open with a MDI vertical toolbar and I open a second form(ACTIVATE,SESSION) also with a vertical MDI toolbar, everything is fine until I exit the second form. The first ...
    Eclipse Technology Inc.Eclipse Technology Inc.
    Mar 19, 1995 at 4:56 pm
    Mar 19, 1995 at 4:56 pm
  • Mark - There was a really good article on configurations in the JAN/FEB issue of Oracle magazine. I have it at home so if you can't get a copy mail me and I'll fax it. I may be avail at the Oracle ...
    Martin G. BradburnMartin G. Bradburn
    Mar 19, 1995 at 4:56 pm
    Mar 19, 1995 at 4:56 pm
  • Hi, I had problems with creating forms before and after some help from Chris Lawson, I fixed that problem. Now, when I tried to open the form (that I generated and executed succesfully and saved), I ...
    EnggEngg
    Mar 19, 1995 at 4:56 pm
    Mar 19, 1995 at 4:56 pm
  • Just a quick question: How does one get fractions of a second in from Oracle's sydate (e.g. yy:mm:dd:ss:tenths of a second). Maybe I haven't looked hard enough, but I can't seem to find it in any of ...
    David WolcottDavid Wolcott
    Mar 19, 1995 at 4:23 pm
    Mar 19, 1995 at 4:23 pm
Mar 1995
12
Group Navigation
period‹ top | Mar 1995 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions99
posts182
users110
websiteoracle.com

110 users for March 1995

Eclipse Technology Inc.: 7 posts Leng Kaing: 5 posts Allen Wells: 4 posts Paul Dorsey: 4 posts SAWMTIM.SME.ORG: 4 posts Tony Jambu: 4 posts A Gentleman and Scholar: 3 posts Bambi Bellows: 3 posts Bruce Pihlamae: 3 posts Chakravarthy Kalyana: 3 posts David Wolcott: 3 posts Farzin Shakibanejad: 3 posts GLENN CARLSTROM: 3 posts Jan Baumgras, 566 Bldg., 6-0443: 3 posts John C Flack: 3 posts LONG, Alex: 3 posts Nick Price: 3 posts Nirmalya Das: 3 posts Srinivas K. Rayapeddi: 3 posts Sunil Godithi: 3 posts
show more
Archives