hi everyone, i am using oracle 9.2.0 and i have written a simple jdbc java program to insert a record within a for loop to a table using jdbc...

and

01-08-2004 11:41 AM
ctcgag@hotmail.com

Hi there. I have downloaded oracle 9i personal edition. But i cant install it on my computer. What happens is i open the universal installer and...

i_:hate_spam

01-08-2004 10:02 AM
Daniel Morgan

All, Iam developing a project and trying both ORacle and SQL Server 2000 as a backend database. As I develop I need access to both and am...

Jawahar Rajan

01-08-2004 10:01 AM
Daniel Morgan

The following SQL runs fine: select s.stylecode "Stylecode", s.name "Description", c.clrcode "Colour Code", c.clrname "Colour...

Prince Of Thieves

01-08-2004 08:41 AM
Niall Litchfield

I am writing a trigger in database A, which calls a Procedure in database B. I get some values back from database B, depending on those values I...

Jeevan

01-07-2004 03:00 PM
Jeevan

Hello, A somewhat perplexing problem that I would like to share, and perhaps in doing so someone wiser will spot what I'm doing wrong. he following...

Saeed

01-07-2004 01:43 PM
Erik

harve_projects (AT) yahoo (DOT) com (HRR) wrote: Select a,min(b),min(c) from sometable group by a;

Turkbear

01-07-2004 01:42 PM
Mark C. Stock

Hi, I don't know too much about triggers but here's my trigger: create or replace trigger license_usage BEFORE DELETE or UPDATE on...

Choung

01-07-2004 12:06 PM
Mark C. Stock

Hi, i'm looking for a sql statement to compute an average from the following sample: Week Value_a ...

Hendrik Lampert

01-07-2004 11:25 AM
Rene Nyffenegger

I have errors when displaying standard report OEM query When I execute a standard report, on some query I have this following error. My Internet...

jeff31

01-07-2004 10:05 AM
Matthias Wirtz

I have the below script. Every year we change the date (dpdate) in it manually so it reflects the beginning of the current year. I just haven't been...

Shawn

01-07-2004 09:29 AM
Turkbear

Do I have to install some sort of oracle client to get classes12.zip to work on linux. I havent tried any code yet. I will assume that I cant just...

bigbinc

01-07-2004 09:03 AM
Phil Britton

Hi! I need some help with Oracle and dates! I have two tables in my Oracle database. I want to select the rows from the first table, that is 3...

rsj@gisportalen.dk

01-07-2004 08:57 AM
Niall Litchfield

I've created the following trigger but it keeps failing: create or replace trigger license_usage BEFORE DELETE on admuser.usession FOR EACH...

Choung

01-07-2004 07:52 AM
Ken Denny

Hi I am a newbie to Oracle SQL. I want to know if somebody could help me with a problem. I have two tables with a date column. I want to select the...

rsj@gisportalen.dk

01-07-2004 06:56 AM
Mark C. Stock

Everytime when I call GetObjectContext.DisableCommit or .SetAbort the cursor does not disappear. After calling several times DisableCommit Oracle can...

Marcus Warm

01-07-2004 05:14 AM
Marcus Warm

Hello This product is very nice and easy to use, the product name is DreamCoder for Oracle. http://www.mentattech.com pete

Peter

01-06-2004 03:58 PM
Daniel Morgan

Hello.. I need a *simple* and *efficient* SQL query like this. (I am working on Oracle 9i) Example) Table T. CA CB CC CD --- --- --- --- 1 G1 ...

June-young Jang

01-06-2004 01:04 PM
Erik

I have to generate another report based on CYCCRP. Obviously Oracle will not send the source code of this one, but researching in Metalink I saw...

lsouzaf

01-06-2004 12:16 PM
lsouzaf

This is more of a general RDBMS question, less of an Oracle question, but I am running Oracle 9i so I am asking here for lack of a better forum. I...

Nico Zigouras

01-06-2004 12:01 PM
Erik

Hi all, Does anyone know if its possible to export an exact explain plan from one database to another database? I've tried stored outlines but the...

Derek

01-06-2004 09:09 AM
Ryan

Hi, I encountered the above error when I tried to startup nomount a brand new database during database creation. The oracle version I am using is...

WaiKhuan Yeoh

01-06-2004 07:40 AM
Daniel Morgan

you can buy the CDs from oracle.com for $40 and get a whole bunch of stuff. problem is it takes 6-8 weeks to come most of the time. beware of giving...

Frank van Bortel

01-06-2004 12:10 AM
Daniel Morgan

Hi, I need to create a trigger that requires input from more than one table, is this possible? I want the trigger to be activated when one table...

Choung

01-05-2004 10:31 PM
Derek

All, I have a table created like so Create table WR_Country_code ( ID number not null, Country varchar2(50) not null, Description Varchar2(255) not...

Jawahar Rajan

01-05-2004 10:26 PM
Derek

Hi, I have a field that stores the date and time but every time I query the table it only spits out the date. What should it say to spit out both...

Choung

01-05-2004 02:47 PM
Daniel Morgan

Hi all. For some time now we are trying to use the DBMS_LOB package, but to no avail. I looked up all similar posts handling ORA-2228x-Errors...

Werner Fangmeier

01-05-2004 01:48 PM
Sybrand Bakker

Hi all, I am wondering if I am the only dude who's struggling with the installation of xsql and related demos, I didn't find much info on this topic...

FC

01-05-2004 01:23 PM
Frank van Bortel

My apologies if this is not the right group for this question. I am trying to use a BETWEEN function in a DECODE statement and I am having a hard...

DFN

01-05-2004 01:07 PM
Daniel Morgan

Greetings, I use C language and OCI develop a program. In a table, I define a field of type number(10), and I need to insert/update this field via...

music4

01-05-2004 02:19 AM
music4

Is it possible to run use TAF for SELECT failover with just two separate oracle databases which are not part of OPS or RAC cluster? My application...

Jim Dwyer

01-04-2004 09:33 AM
Galen Boyer

After installing Oracle as the local administrator account, "normal" users on the same PC can't start sqlplus or any other Oracle tool and get a...

Rick Denoire

01-03-2004 08:16 PM
Daniel Morgan

Hi I have a problem with a update. I recive this error ORA-00942: table or view does not exist ORA-06512: at "F0001.UPDATE_MASUPTR", line...

Patrik

01-03-2004 03:46 PM
Phil Singer

Hi Group, is there _any_ way (Server Parameter?) to make Oracle store empty strings in Varchar2s without converting them to NULL? Thanks in...

Keith Sauvant

01-03-2004 05:41 AM
Frank van Bortel

All, I am trying to use the following trigger. It is a Schema level trigger, that should run each time a table is created. I am trying to create a...

Jawahar Rajan

01-02-2004 07:15 AM
Ken Denny

Hi, I'm attempting to come up with a SQL script that calculates disk space usage with columns for Total, Free, Used, %Free & %Used. I think...

Jon

01-01-2004 09:48 AM
Mark C. Stock

Does anyone use these? What type of information do you place in them?

Scott Mattes

01-01-2004 09:36 AM
Mark C. Stock

i have code OPEN csr_CDPM for v_ExecuteSql; LOOP FETCH csr_CDPM INTO Cdpm_eSchedule_rec; exit WHEN csr_CDPM%NOTFOUND; insert_Ctr := insert_Ctr +...

Sumit Khanna

12-31-2003 08:07 AM
Sumit Khanna

Hello All, Can anyone please explain to me why you would need to use Nested tables and give an example. Also can you show the SQL to view the table...

Ritesh Kachhwaha

12-31-2003 06:12 AM
Tony

Dear Hi: Hope to see u in good health. I was surfing Internet for some Oracle resources, and I found that you are a Guru in Oracle, so here Iam...

Azhar Bilgrami

12-31-2003 03:17 AM
Azhar Bilgrami

usual chain letter scam. <snip>

Jim Kennedy

12-30-2003 09:59 PM
Jim Kennedy

I have this SELECT statement in a cursor that's giving me performance problems and am wondering if reordering the conditions in the WHERE clause...

Ubiquitous

12-30-2003 09:44 PM
Phil Singer

Hello everyone. I hope someone can help me with this. I have 3 columns called EMPLOYEE_TEST, TEST_QA and EMPLOYEE_TEST_ANSWER. The TEST_QA table...

Emilio Navarro

12-30-2003 09:14 PM
Emilio Navarro

Hi all, I am working on a project using Oracle9i and encounted a question as belows: A Table like this: create table account (sdate date,svalue...

Coca

12-30-2003 07:19 PM
Matthias Wirtz

I am using Oracle Applications 11.5.7 on Windows 2000 SP2. There is a feature in OA by which we can create alerts. The alerts send emails if...

Adrienne Lovell

12-30-2003 02:08 PM
Adrienne Lovell

Is there any way to specify the oracle lite 9i database to use UTF8 charset

Angus Chan

12-30-2003 01:50 AM
Angus Chan

Guidance Please, I'm encountering make errors when installing Oracle 9iAS R2 9.0.2.0.1 on SuSE 8.2 Professional. The following error is...

Yakub

12-29-2003 10:41 AM
DJ

Hi, I have a listener problem. The listener cannot read SERVICE_NAME in TNS-Descriptor. The service-name I specified in Oracle Net Manager for this...

Axel Dachtler

12-28-2003 09:35 AM
Sybrand Bakker

Hi there, it's me again with a next question: I have a textbox and there I wanna put several numbers in. But I wanna check if the user gives...

Bomanews

12-27-2003 11:39 AM
DJ

Greetings, I have question which was probably discussed million times before, but I was not able to find an answer. I have little application...

Pavel Vetesnik

12-27-2003 06:47 AM
Frank van Bortel