My setup is: An Oracle 9.2.0.1.0 Enterprise Edition Win2K DB server with ConnMgr installed and running. The DB looks fine and I can connect via...

Dave Penn

08-07-2004 01:20 PM
Dave Penn

what is the best way to calculate: (in the context of an update) the number of transactions that were entered in the same way as the current...

Wil Simpson

08-06-2004 07:10 PM
Wil Simpson

Hello all, I am trying to test an ODBC connection to an Oracle dbf using the ODBC Data Source Administrator. It's not working and I suspect I...

GitarJake

08-06-2004 12:42 PM
Teresa Redmond

-bash: /mnt/cdrom/runInstaller: /bin/sh: bad interpreter: Permission denied solution for this error while installing Oracle10g on Linux is...

Parag

08-05-2004 12:57 PM
Parag

Can anyone tell me if the predominent language of the breakout sessions is English? Does anyone have a detailed agenda from last year. the current...

Brady

08-05-2004 11:05 AM
Brady

Hi, how can I save a big Process Modeler diagram (Oracle Designer 6i rel. 4.9) as an image file in Windows environment? After I copy it to...

TW

08-04-2004 07:22 AM
TW

I am fairly new to Oracle and I would appreciate if some one can point me to a right direction. I have store procedure that takes about 3 minutes to...

Gene Ariani

08-04-2004 01:10 AM
Haximus

I'm a novice in data base and I'm working on Data warehouse. I'd like to know websites giving examples of methods used for listing up datas stored...

vashy

08-03-2004 10:30 AM
Michael J. Moore

Hi. We had a PC that had Oracle Client 8.0.5 and 8.1.7 installed in Default_Home (c:\orant) and Default_Home1 (c:\oracle). A third party package,...

John

07-31-2004 03:54 PM
Philippe Valentin

Hi, Can someone tell me how i can get table/view script by using SQL*Plus? as i know we can get procedure and function through USER_SOURCE. Thanks.

cy1610

07-31-2004 01:22 AM
Philippe Valentin

I am running Oracle 9i on Win2003 and am trying to restore a database that was backed up from a Unix environment. I am far from a Oracle expert just...

Deon

07-31-2004 12:58 AM
Philippe Valentin

Hello, I am a newbie trying to create an API written in C# that connects to an oracle database and reads/inserts records. right now, i've got...

goldenorb82

07-31-2004 12:25 AM
Philippe Valentin

Hi good people.I would like to be an Oracle DBA. I would be glad if any of you could give me an idea of the exams that I would have to write. Thank...

KAREN

07-31-2004 12:18 AM
KAREN

How can I do this in a single select statement? Table A Name ID Eric 1 Jeff 2 Ted 3 Tad 4

Root

07-29-2004 10:44 PM
Michael J. Moore

I have field that looks like this Person-12345-(thanks) I need to select the number in the middle. 12345 Please help... also the first text...

Gotosleep

07-28-2004 12:34 AM
Philippe Valentin

We have Oracle 9.2 and Application Server. We got our Oracle server delivered with the user tablespace in the app server database (IASDB). We would...

Lester L. Noll

07-26-2004 03:30 PM
Lester L. Noll

Our application which is running on a Sun Solaris system, uses an Oracle database, containing lot of tables and millions of records within it. We...

qazmlp

07-24-2004 11:14 AM
qazmlp

Hi, I am unable to connect to Oracle database from another server using Client/Server relationship. (FYI...Program is written as Pro*C using Oracle...

Ursula Lee

07-18-2004 10:26 PM
Ursula Lee

Hi all, I have a client/server setup which I would like it to communicate as follows: Server: Loop Write something to client via writeUTF()...

Michelle

07-18-2004 06:06 AM
Michelle

Is it possible to tunnel oracle connection? There are: 1. client in LAN without fixed IP address, behind firewall, with only http connection to...

monisiatko

07-17-2004 06:46 AM
Pete Finnigan

I'm working on a query that has to provide values with a specified number of significant figures. What I've done so far is to...

James B. Millard

07-16-2004 05:44 PM
James B. Millard

Hi, I am TOTALLY new to all this stuff and really hope to find help here. I have to come up with a solution for one of my client. They use HP-UX...

Dominic

07-15-2004 04:04 PM
Dominic

We have a development and production database for an application. Every day after work on the development database I want to update (and or recreate)...

Sulla

07-12-2004 12:07 AM
Michael J. Moore

Below is the sql for data with same date need to extract + or - 5 days data of same date also. How to also get data of + and - days related to same...

captain

07-12-2004 12:05 AM
Michael J. Moore

I would like a general-purpose PL/SQL proc for outputting the contents of a table or view to a text file, with the field values separated by...

Sean

07-11-2004 11:54 PM
Michael J. Moore

I'm trying to install oracle 9i on my laptop. I am wondering if I can use Apache server to run the DB. I'm stuck at the option where it asks for a...

papadon

07-10-2004 07:16 PM
papadon

Hi , I am trying this on v91. Is this a known issue? select * from ( (select * from oj1 left outer join oj2 on oj1.c1=oj2.c1 ) t1 left outer...

Aakash Bordia

07-09-2004 01:47 PM
Aakash

How to start xternal aplication or bath from PL/SQL procedure ?

AW

07-09-2004 04:07 AM
AW

I am pleased to announce that version 0.5 of VTD-XML -- a new, non-extractive, Java-base XML processing API licensed under GPL -- is now freely...

Jimmy zhang

07-05-2004 12:28 PM
Daniel Morgan

Hi, I'm working with Oracle9iAS Portal which my users use to access an oracle forms application through a link. It is configured as an External...

Energumeno

07-02-2004 11:36 AM
Energumeno

Can anyone tell me why this Trigger won't compile correctly? CREATE OR REPLACE TRIGGER REQ1_NEWREQ_TRIGGER_GCSIFOMTO AFTER INSERT ON...

Web Tracer

06-29-2004 04:00 PM
Web Tracer

I am using Oracle DB 9.2.0.4.0 on my IBM AIX 5.1L Systems. I have 2 instances of Oracle running - "UTAH" and "UTAH_TEST" on the same server. "UTAH"...

HARI OM

06-29-2004 01:57 AM
Mladen Gogala

I'm getting the infamous ora 12154 - TNS could not resolve connect identifier error. My computer is running windows 2000 pro in standalone mode (not...

George

06-25-2004 01:50 PM
George

Below is the actual error message we receive after running our script for backup... ORA-01190: controlfile or data file 7 is from before the...

Sady

06-24-2004 01:40 PM
Sady

Hi everybody, TO make a SQL Trace, I have been install some packages ? If yes, wich is those ? Thanks all Bernard

Bernard Koninckx

06-24-2004 03:24 AM
Bernard Koninckx

Hi everybody, I'v downloaded Personal Oracle 8i and I would like training me for the tuning of SQL queries. In a book, than I have he said, first...

Bernard Koninckx

06-24-2004 03:10 AM
Bernard Koninckx

Hi everybody, I'v downloaded Personal Oracle 8i and I would like training me for the tuning of SQL queries. In a book, than I have he said, first...

Bernard Koninckx

06-24-2004 03:07 AM
Bernard Koninckx

Is there an Ant extension, or external commands available that would allow me to create a target that would re-compile Oracle packages, and to...

schmen

06-23-2004 10:17 AM
schmen

11i Oracle has replaced the Expense distribution report APXEDRBS with a Payables account analysis report. and the users strongly prefer the...

Gene Maillet

06-23-2004 09:16 AM
Gene Maillet

Hi, I have an Access 2000 database, which contains some native tables, and some linked tables which belong to an ORACLE database,...

anand

06-22-2004 02:54 PM
Paul Clement

Hi NG, gibt es eine Möglichkeit sich aus einer bestehenden Oracle-Installation ein Datenmodell zu generieren. Oracle ist installiert und das...

kielhd

06-22-2004 08:11 AM
kielhd

Is this the group from whence Daniel Morgan posted his threats about getting poets fired from their jobs and kicked offline? Jes curious. Jade

Daedalus

06-21-2004 04:12 PM
Daedalus

can I do a cluster Install for Oracle Application Server ? or cluster installation can be done only on the database installation? shimi

Shaju

06-20-2004 12:03 AM
Shaju

Hi friends, I am making a database project using oracle as backend and visual basic as front end. My project is "Cricket database". Cricket is a game...

git_cs

06-18-2004 11:23 PM
Jim Kennedy

Hi, I am getting wrong results from an oracle text query. SELECT COUNT(*) FROM dwh_dist_item WHERE pack_info LIKE '%#2.5%' COUNT(*) -------- 566

raj

06-18-2004 04:14 PM
raj

Hello, I am an absolute beginner in ORACLE, and I have the following problem - I'll try to explain it as clearly as possible. I'm working on...

Radu

06-18-2004 11:41 AM
Radu

I did a normal install of 8i on a solaris 8 x_86. I did the full enterprise install. When I try to start up the oem, it says that the ...

markt

06-18-2004 03:24 AM
markt

Can anyone point me in the right direction? Using Oracle 9i, Pro*C and Excel. I am trying to print french accents from the Oracle DB using Pro*C to...

c w

06-18-2004 01:31 AM
c w

I just upgraded my home system from Oracle 8i to 9i. Everything works great except for one little problem. After I start up my computer, the Oracle...

Charly Walter

06-17-2004 05:37 PM
Michael Austin

Hi again! ^_^ i'm trying to get some results from a cursor with this procedure.. (oggetto in varchar2, pagina in number, numero in number, rife...

kintaro

06-17-2004 05:34 PM
Michael Austin