Hi I have the following query aggregating values over a column and creating the sum over another column. Here everything works out fine. SELECT...

marc.daetwyler@bawag.com

03-15-2005 02:06 PM
Ed Prochak

HI , My application runs fine when I am using SQL Server 2000 as its db, but it gives a message "Invalid attribute/identifier" error when the db is...

ghosh.sujay@gmail.com

03-15-2005 10:55 AM
Mark C. Stock

HI, I have an XMLType column that has the following XML structure: <Client> <Report id = "01"> <Item id = "01" Description = ",a.mdfbnelt;yuk"...

ccote_msl@yahoo.com

03-15-2005 07:57 AM
GreyBeard

Hello, We were having trouble connecting to Oracle 8.1.7 running on a Solaris machine. We assumed this was because a firewall blocked access to port...

laredotornado@zipmail.com

03-14-2005 02:58 PM
Frank van Bortel

Hello, i have a big problems, to install oracle 9i v9.2 Server to my "Windows XP" with Service Pack 2 and all security and other updates...

black hawk

03-14-2005 11:58 AM
Frank van Bortel

Hello EveryBody, I had installed Oracle client 8.1.7. Now I want to install Developer 6i under the Oracle 8.1.7 home. When I tried to install this ,...

vikas.rijhwani@gmail.com

03-14-2005 11:26 AM
Eric de Redelijkheid

Hello, i have a big problems, to install oracle 9i v9.2 Server to my "Windows XP" with Service Pack 2 and all security and other updates...

black hawk

03-14-2005 08:23 AM
black hawk

I was trying to install Oracle on a Linux box with Redhat and got an error message saying the OS had to be Redhat 2.1 or 3.0 (plus some...

tim@nocomment.com

03-14-2005 03:02 AM
Bašiæ Alen

Hi I'm beginning with PL SQL and try to learn cursors usage I get ora 920 with this on line "WHERE WHERE_NORME " What i'm trying to do is to fetch...

mrique

03-12-2005 09:17 AM
mrique

Salve. I have an application in which I would like to convert a number of seconds into an INTERVAL DAY TO SECOND value and, later, back to a number...

angrybaldguy@gmail.com

03-12-2005 07:36 AM
Frank van Bortel

Could someone be of assistance and show me the problem with the following code? I have researched Metalink regarding ORA-29531, and the most common...

jkstexas2001@yahoo.com

03-11-2005 03:08 PM
GreyBeard

We have a few rather advanced calculation routines developed in C++. Currently we are using a Sybase ASA database for our app. and these routines are...

Peter Sullvan

03-11-2005 08:49 AM
Peter Sullvan

Hello people! I am a bit puzzled here so any help will be much appreciated. Here is the situation: I have a query which selects all the data based...

DMina@laiki.com

03-11-2005 04:22 AM
Bobiander

Hi ! I am trying to learn how to use Oracle Discoverer. I have worked with databases, like Oracle for several years, but i am new to...

Ole Hansen

03-10-2005 04:18 PM
GreyBeard

Hello out there, this morning I had to get some rows via flashback query. Since my undo retention is just 3h, the undo segments were already aged...

Lothar Armbr?ster

03-10-2005 04:02 AM
Carlos

Anybody knows if it is possible to use gdb/dbx to debug .pc file instead of generated .c file? Thanks

modemer

03-09-2005 05:46 PM
modemer

Hi, I am looking for PL/SQL examples for beginners. Can anyone help me find few??? Thanks in advance pavan

Pavan

03-09-2005 12:18 PM
George Lewycky

There is again a rash of people asking question in comp.databases.oracle and these people are likely disappointed at the lack of responses. Please...

GreyBeard

03-09-2005 08:14 AM
GreyBeard

I'm looking for a link where I can find details about pro*c compilers for windows. Anyone can help? Thanks

Golan

03-09-2005 07:59 AM
GreyBeard

Hi, I want to use the Oracle dbms_application_module's set_module and set_action functionality for tracing my calls. However my client uses JDBC to...

Digvijay Lamba

03-08-2005 09:08 PM
Digvijay Lamba

Hi, I have started using Spotlight to monitor a few oracle 8i databases and wonder whether there are any papers detailing what all the indicators...

Jim

03-08-2005 06:39 PM
Daniel

I have two SQL statements: Statement...

Alex

03-08-2005 08:57 AM
Frank van Bortel

I'm looking for a link where I can find details about pro*c compilers for windows. Thanks in advance

Golan

03-08-2005 05:35 AM
Golan

In my research, I want a sample database with SQL triggers in order to validade my testing approach. Unfortunately, I can´t find actual databases...

Plinio Leitao

03-07-2005 03:04 PM
Plinio Leitao

Hi, Can someone please tell me how to open a help file through forms. I have tried the HOST() command which was detailed in a previous topic however...

davidwelch40@yahoo.com

03-07-2005 02:58 PM
Frank van Bortel

Hi Oracle support send me an anual fee with - Product Support - Software Updates I run 9i Oracle Database Standard Edition - Processor Perpetual I...

mrique

03-07-2005 02:57 PM
Frank van Bortel

hi all, I am programming on linux, my program want to connect a oracle database server to do some SQL statement/procedure. But I don't know how to...

baumann.Pan@gmail.com

03-07-2005 07:47 AM
baumann.Pan@gmail.com

Hello, I already succeed to call a stored procedure in Oracle but only simple ones with one output value and several inputs. I don't any idea...

stephane.traumat@gmail.com

03-06-2005 05:32 PM
stephane.traumat@gmail.com

Hi, I have an Oracle 8i instance which has somehow managed to store the 29th of February 2005 in a date field. As 2005 isn't a leap year this is an...

GaudaPrime

03-06-2005 03:43 PM
GaudaPrime

I would like to ask for clarification on the meaning of these two columns. According to the 9i Ref, object_id is the dictionary object number of the...

Jack

03-04-2005 12:57 PM
Jack

Hello, I have a stored procedure and I want to pass it a NUMBER parameter to make a select inside it as the following: SELECT * FROM...

2much4u

03-04-2005 11:37 AM
2much4u

Hi, I have the following problem: We have an Oracle 9.2 with one table "document" which contains a path to the filesystem. If I want to index these...

Nikola Pecigos

03-04-2005 04:49 AM
Frank van Bortel

I have tableA, defined as: field1 varchar2(10), field2 varchar2(10), field3 varchar2(10) I have host variables defined as: v1 pic x(10) varying v2...

Chris

03-03-2005 12:43 PM
jce

Hello, I am attempting to attach a .pdf file to an email generated using oracle's utl_smtp. I am working on Oracle9i Enterprise Edition...

scott.watson@apollogrp.edu

03-03-2005 11:45 AM
scott.watson@apollogrp.edu

Hello, I am attempting to attach a .pdf file to an email generated using oracle's utl_smtp. I am working on Oracle9i Enterprise Edition...

scott.watson@apollogrp.edu

03-03-2005 11:45 AM
scott.watson@apollogrp.edu

Hello, I am attempting to attach a .pdf file to an email generated using oracle's utl_smtp. I am working on Oracle9i Enterprise Edition...

scott.watson@apollogrp.edu

03-03-2005 11:45 AM
scott.watson@apollogrp.edu

The DB2 User Group Italy(DUGI) is holding its next meetings in Rome on March 15th and in Milan on March 16th. For full details about the events,...

adrian.collett@technites.it

03-02-2005 04:15 PM
adrian.collett@technites.it

I need to be able to connect Oracle to SQL Server using JDBC and loadjava. I have written a java class that I can execute on the platform fine. ...

swtwllm@alum.iup.edu

03-02-2005 02:03 PM
swtwllm@alum.iup.edu

Hi all, when i set a date field's type (12) to VARCHAR2 or STRING, I get the date (mm/dd/yyyy) correct, but I can never get the time which is...

deadlocklegend@gmail.com

03-02-2005 04:25 AM
Mark C. Stock

Hi I installed oracl lite 10g and I wanted run sample code for ADO.NET but they wrote in HELP that I should make references Oracl.DataAccess.Lite ,...

biela

02-28-2005 10:08 AM
biela

Does anybody know where I can get the latest patch (17) for Oracle Development Tools 6i.

Larry

02-28-2005 07:34 AM
Frank van Bortel

Hello to all, I've oracle developer 6. My all reports are in character mode and its also print well in Windows 98. But when I print it from Windows...

Asif Abbas

02-26-2005 05:51 AM
Asif Abbas

Is their any support for data compression while using Oracle JDBC driver (8i or above) Thanks

goyald@gmail.com

02-25-2005 07:01 PM
goyald@gmail.com

What is the best freeware SQL GUI Client for Oracle/SQLServer/Sybase under Win2000/WinXP? With SQL Squirrel and DBVisualizer (free version) I...

George Dainis

02-24-2005 02:31 PM
George Dainis

Hi, In my web app , i am using oracle 9i as db.i an open the oracle database but i cant retrieve the data. It tells ORA-00376: file 7 cannot be...

Raghuraman

02-24-2005 12:48 PM
Eric de Redelijkheid

Hello wisers, We are testing a system which is developed on top of Oracle 9iAS. The client PCs are using Internet Explorer to access the system. We...

bjwang@acs.com.tw

02-24-2005 03:19 AM
Frank van Bortel

Hello Does anyone know where to set the iSQLPlusTimeOutInterval parameter in 10g ? (In previous versions this is done in the isqlplus.conf file,...

Jakob

02-21-2005 08:54 AM
Jakob

Hi, Recently I have been looking at the various ways people are implementing, interaction between java & oracle databases. I was always instructed...

steve

02-20-2005 01:37 PM
Haximus

Hi, I have an SQL assignment to do and at my school we use SQL *Plus there however I don't have Oracle at home, where I would like to do the work...

Ant

02-17-2005 08:45 AM
Mark C. Stock

Hi, I'm having problems using sqlplus on OS X. I'm trying to connect to my college's server. They supplied the tnsnames.ora. If I run 10g...

Doug

02-16-2005 10:06 PM
Doug