Hi, recently i install oracle 10g server on windows pc, but some of the services take port number 8080 which is conflict with our application server...

db2group88@yahoo.com

08-11-2004 04:50 PM
db2group88@yahoo.com

Hi, The sql query below returns data in the 'note' field from a table called ww_rec_1 from the previous month and displays the sum of hours for each...

George

08-11-2004 01:43 AM
Pratap

I know that Oracle has extensive support for XML, but I can't seem to find any documentation on using an XML document to do multiple inserts into...

Brian Marasca

08-11-2004 01:41 AM
Pratap

Hi, I would like to know how to perform the bulk insertion of binary data using the OCI. Thanks, Tuhin

Tuhin Kumar

08-11-2004 01:32 AM
Tuhin Kumar

I am looking into getting certified in Oracle. Does anyone out there know which books are the to buy? Any information anyone has about...

redraiderqt

08-10-2004 09:22 PM
Hans Forbrich

hi all, I have a view that has data from this year as well as previous years. the select statment looks something like this: create view as...

MT

08-10-2004 08:20 PM
MT

Dear friends of database(s), After 13 years of Ingres, I am now using Oracle. But is Oracle technically better than Ingres. I would be much...

michael newport

08-10-2004 07:27 PM
Mark D Powell

I'm trying to work out an average field on a report that i'm writing and having the problem described below. e.g. if you had 3 weeks of cash which...

PeterHardy

08-10-2004 08:07 AM
Adem

I must advise you these people are late payers. They also employ people who fiddle their timesheets all the time. Having worked for them on and off...

blazerfivenine

08-09-2004 02:55 PM
David Horsman

Hi. We have a problem we'd like to circumvent. There is a stored procedure that sets a savepoint, do whatever, and if there is an error, it rollbacks...

GMonce

08-09-2004 09:29 AM
Mark D Powell

I have 3 Oracle servers that I would like to keep in sync. Only one is used as my production, the other is a backup and the third is used...

~K

08-08-2004 10:31 PM
Hans Forbrich

hi friends, i have one query related to oracle9i outer join condition it is mentioned that we can't use (+) with the operand of OR and IN...

Rahul Khandpur

08-07-2004 10:45 AM
Brian Marasca

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

Hi, I'm having a bit of trouble with an update performed by a PL/SQL routine that is updating more rows than it should be. Here's some of the...

Beelzehubub

08-06-2004 04:26 PM
Mark D Powell

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

Hello everyone, I'm an oracle database adminstrator and I search some information about possibilities to create easy forms for data input (for...

Thomas Kindermann

08-06-2004 11:52 AM
ChetWest

Hi, I need to do bulk insertion of LONG RAW data into a table using the OCI. To the OCIBindByPos API what should I specify in the...

Tuhin Kumar

08-06-2004 09:14 AM
Tuhin Kumar

Using Oracle 8i, when I issue * (seems to be random number of times) number of update statements my app hangs while waiting to execute the next...

harry

08-05-2004 10:12 AM
harry

I use an application that uses Oracle 8.1.7. All functions of the application are completed with calls to stored procedures. A data entry error...

Chris Cowles

08-04-2004 07:19 PM
Chris Cowles

Hello everyone, We are looking for beta-testers for our new product - Scribe Report Generator. At this moment, Scribe supports 6 relational...

Alexandr Molochnikov

08-04-2004 02:47 PM
Alexandr Molochnikov

i need a sql-statement for this problem i ve got a table like this ID;value 1;30 2;34 3;44 the result of sql-statement should calculate differences...

beyond

08-04-2004 10:13 AM
Mark D Powell

Hello, in Oracle Enterprise Manger Console i declared an array-type. Then i created a table which uses this type. How can i now insert an array to...

Red_Viking

08-04-2004 03:31 AM
Red_Viking

hi, xmldom accepts win1251 but deals with UTF-8 only my Client app. will be not happy seeing UTF-8 in incoming XML messages so --UTF-8 ->...

Andrey

08-04-2004 01:38 AM
Andrey

does anyone knows, how to encapsulate pl/sql-packages into DAO-object (java)? we are considering to separate logic from data-structure in...

beyond

08-03-2004 04:32 PM
beyond

i need for our data-warehouse-project a concept for generating views: i want to prepare the relational database-structure (physical) for a reporting...

beyond

08-03-2004 04:10 PM
beyond

Hi everyone First of all,i don't know about tablespace so please give me full detail about tablespace. Thanks.

jain_amit_jhs_grp@yahoo.com

08-03-2004 10:17 AM
Hans Forbrich

Hi all, I am in search of any Enterprise level Opensource Project that uses Java Stored Procedures supported by Oracle. I could not find any...

Suresh Tri

08-03-2004 09:24 AM
Jim Kennedy

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-03-2004 04:03 AM
sybrandb@yahoo.com

I'm trying to run a SQL query but can't find any records when trying to select a certain date. Here's the sql: SELECT field 1, field2,...

vnl

08-02-2004 07:02 PM
vnl

Hi, I have a question regarding Oracle 10g and it's dynamic SGA. We are currently evaluating different hardware platforms as well as...

Erik Hendrix

08-02-2004 04:59 PM
Erik Hendrix

Can anybody help me solve this problem in Oracle: "ORA-01552: cannot use system rollback segment for non-system tablespace 'PTTBL' " Thanks!

R.Saminathan

08-02-2004 05:35 AM
sybrandb@yahoo.com

Hi all, I am interested in extracting the class or jar files which are stored as java stored procedures in Oracle. But I want to know if these...

Suresh Tri

08-02-2004 01:58 AM
Suresh Tri

Hi I have a corrupt PK index on a table column. It is a unique PK. It needs to be dropped and recreated to cure the corruption. The table is on a...

Thiko

08-01-2004 09:27 PM
Mark D Powell

we have a strange problem with oracle dynamic sql method 4. when selecting a substr we expect to, and normally, receive from oracle in the describe...

Ari

08-01-2004 07:01 AM
Marat

hi all, i have two tables BOOK ------------------------------------ CODE NOT NULL NUMBER TITLE VARCHAR2(45) YEAR ...

castor.

07-31-2004 06:57 PM
castor.

Hello, I'm new with Oracle JDBC connection. Is it a way to crypt, hide the password string into a Oracle JDBC connection string ? The goal is to hide...

Kona

07-31-2004 06:03 AM
Soeren Degn Jahns

Hello, I am a .NET newbie and have been doing a lot of reading to answer my question, but i am guessing that it is so basic, there isn't a...

goldenorb82

07-31-2004 12:21 AM
Jim Kennedy

We need to create a lookup structure that can contain a flexible amount of attributes. We have discussed different design solutions for...

Anders

07-30-2004 01:59 PM
Chris Leonard

Hi All, We have one column with low cardinality, 4 or 5 unique values across 50 mil rows. Our query has this colunmn as a predicate. Binary index...

Vissu

07-30-2004 10:08 AM
Mark D Powell

What is the best way to lock an individual row in the following scenerio: --TODO - LOCK THIS ROW -- Return the next...

Andrew Baker

07-30-2004 07:14 AM
Andrew Baker

Hi, I herarded that is special law for ORACLE database administrators, so if anybody knows something about that please infor me. Thanks in advance...

Robert Bralic

07-29-2004 04:46 PM
Mark D Powell

Hello everyone, We are looking for beta-testers for our new product - Scribe Report Generator. At this moment, Scribe supports 6 relational...

Alexandr Molochnikov

07-29-2004 12:56 PM
Ed prochak

hi, Want to count rowid. One row by one row and on each do a calculation and than go to next or previous row. In oracle it is Rowid, wonder how to...

captain

07-28-2004 01:32 PM
Ed prochak

Has anyone seen this before? I start SQL*Plus, and login by typing sqlplus Quantum/Password@BPrd I type: select '&1' from dual; it responds

Peter

07-28-2004 09:26 AM
Mark D Powell

Our company developed the last couple of years a development tool: using this tool we configure and program (using SQL, and Java-Script) very, very...

Chris

07-28-2004 05:49 AM
Chris

The Summer Conference of the Northern California Oracle Users Group will be held on Thursday, August 19, 2004 at ChevronTexaco in San Ramon. This...

Northern California Oracle Users Group

07-27-2004 03:54 PM
Northern California Oracle Users Group

How do I increase the performance of a SELECT query with GROUP BY clause?

MP

07-26-2004 11:03 PM
Bricklen

I'd appreciate some help I'm having trying to run a cursor. First, some background. The Status field of all records on Table A needs changing from 1...

RayP

07-26-2004 12:02 PM
Mark C. Stock

I have a stored procedure which returns several ref cursors. I have a few requirements which I am trying to achieve. 1) Ensure SQL is easy to...

Tim Smith

07-26-2004 01:18 AM
Tim Smith

Hi, I have a piece of code (attached bellow) that grabs the names of several tables in my schema. I now want to grab a maximum value of one of the...

Doron

07-25-2004 01:57 PM
padmaja_kad@yahoo.com