I have tried to install the new Oracle10gSolarisx86 on Solaris10 but this is not possible. Only on Solaris 5.6 5.7 5.8 5.9 !!!! Wolfgang

Wolfgang Maron

07-25-2004 03:04 AM
Wolfgang Maron

Hi SQL Masters, I know its probably a simple query, but I've spent a long time on it and could not figure it out. I'm trying to select distinct...

Tao

07-23-2004 11:32 PM
Michael J. Moore

This is probably a very elementary question. I would like to have an sql which returns the name of the Oracle server and the current database....

Richard Gjerde

07-23-2004 08:13 PM
Mark D Powell

Hi, anybody familiar with any online PL/SQL programming courses I can look up on the web?

Doron

07-23-2004 04:10 PM
Soeren Degn Jahns

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-23-2004 03:31 PM
Alexandr Molochnikov

On this piece of code: When SELECT returns nothing sqlca.sqlcode = 0 and no_data_found_func isn´t called. How do I know if the insertion was...

Pedro Oguri

07-23-2004 12:52 PM
Mr McGeek

Our client is a leading bank and they have the following immediate requirement. Oracle Datawarehouse Consultant Strong Data warehousing skills. -...

Bevertec

07-23-2004 11:12 AM
Bevertec

I'm looking for anyone who is using these two products together. I'm having a difficult time finding information on this combination and Oracle and...

John Parker

07-23-2004 09:24 AM
John Parker

I hate it - i really do. PL/SQL is horrible Regards, Mr Fiddle moe_fiddle (AT) thegolfcourse (DOT) com

moe

07-23-2004 09:02 AM
Ed prochak

Hi, I was creating a trigger to fire when a user ends a session, but I see that you could have it fire on a SCHEMA event : CREATE TRIGGER...

Michael

07-23-2004 08:59 AM
Ed prochak

Suppose my current control file of database is corrupted. Now i have only one backup of my control file that is i have taken when my database was...

gaurav chandra pandey

07-22-2004 11:32 PM
Hans Forbrich

Hi Techies, Am really new with the Oracle 9i Forms and am searching for a way to perform Load Balancing in Oracle 9i Forms Application. Its not a...

yagish

07-22-2004 08:06 PM
Ana C. Dent

Hi, We need an Oracle expert to help us convert a SQL appication to Oracle for a particuler project we're working on. We have all the stored procs.,...

Steve Wells

07-22-2004 12:34 PM
Steve Wells

Has anyone created a user function to return the ordinal position based on numeric input? In other words, f(1) returns 'st', f(2) returns 'nd', ...

Terry Coccoli

07-22-2004 11:32 AM
Mark D Powell

Folks, In INFORMIX there is a default value called DBSERVERNAME that can be assigned to a column during the table definition as follows: create...

Rajiv Jhaveri

07-22-2004 10:58 AM
Rajiv Jhaveri

Hi. I have a stored procedure on a Oracle 8.1.6 database that generates a dynamic sql statement. This stored procedure has an output parameter that...

Robert Scheer

07-22-2004 10:03 AM
Robert Scheer

Very strange behavior - I ran into a scenario where the CBO (Oracle 8.1.7) actually computed a negative value for a cost of a query (and in turn,...

Kevin

07-22-2004 03:58 AM
sybrandb@yahoo.com

I need help trying to optimize a SQL query. I am using Oracle 8i. I have a table with about 1.2 million records, lets call it T1. I am doing a join...

Haider Kazmi

07-21-2004 09:03 AM
Misho

Hello there! I am trying to put together a list with criteria which are considered important for consolidating Oracle Database Servers. If someone...

Demetris

07-21-2004 01:35 AM
Demetris

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

07-20-2004 09:30 PM
Bricklen

I'm posting this in hopes that it will help a few folks out when the search Google Groups. I was having the following problems with Oracle 10G: 1....

Captain Obvious

07-19-2004 11:55 PM
Captain Obvious

Hi, I'm trying to write a view that returns a historical view of records as of a certain date. The records come from a live and historical table and...

Mark

07-19-2004 03:40 PM
Wit Serdakovskij

Table A Name Score A 12 A 22 A 88 B 34 B 12 C 33 C 55

David

07-19-2004 03:28 PM
AK

Hi, I want to insert the result of a select into a procedure-variable within a while-loop. The loop works as far as I don´t insert...

bert

07-19-2004 12:56 PM
Ed prochak

I've read (and lost the reference) that when doing joins of this form: A.col = B.col and A.col = C.col It is "helpful" to explicitlty add...

bugbear

07-19-2004 11:15 AM
bugbear

Hi I want to extract some chinese data. data are stored in ORACLE 8 (DB Character Map is US7ASCII) but data are using NLS_LANG...

Dhwan Kim

07-19-2004 05:05 AM
Dhwan Kim

can not open database because of this, what I can do in this sceneiaro? complete or incomplete recovery? database was closed because of media crash....

Niy

07-19-2004 04:04 AM
sybrandb@yahoo.com

Hi, I need to access more that 1 instance, is there a way to start a new connection from a pl/sql script ? eg. inst1 has table I1 inst2 has table...

naimy

07-19-2004 04:02 AM
sybrandb@yahoo.com

Hi, I am looking for a library(j, c++, or algorithm) which can check and correct sql. For example, if I have selet * from employee where id in...

quikquic@yahoo.com

07-17-2004 10:37 PM
quikquic@yahoo.com

HI, I'm trying yo improve the performance of the following piece of code. Here I'm archiving Items that are done processing to Archive Tables. I...

Diego

07-16-2004 11:59 AM
Diego

Our client is a major bank and we have the following immediate requirements. Oracle Data Warehousing Consultant We need 2 resources with the...

Bevertec

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

Hello, I want to return multiple queries from a procedure in Oracle, I know that o can do that with REF CURSOR. But I have a problem I have a query...

Urko

07-16-2004 04:10 AM
Urko

Hello, I want to return multiple queries from a procedure in Oracle, I know that o can do that with REF CURSOR. But I have a problem I have a query...

Urko

07-16-2004 04:09 AM
Urko

I have tried to solve this on my own for a long time now, so i really need some help here... I use Oracle 10.1 and SQL *plus 10.1. How do i update...

amwi

07-15-2004 01:10 PM
Ed prochak

Hi, For Oracle 9i, the sample make file for the Oracle Pro*COBOL precompiler has a hard-coded list of programs in it. Has anyone created a generic...

VictorReinhart

07-14-2004 10:22 AM
VictorReinhart

Hi All, I 'm using Oracle 8i and i have a table table1 with two columns: COL1 not null COL2 DEFAULT 'N' if i make an insert : insert into...

was

07-14-2004 10:21 AM
Wit Serdakovskij

Hi All, I 'm using Oracle 8i and i have a table table1 with two columns: COL1 not null COL2 DEFAULT 'N' if i make an insert : insert into...

was

07-14-2004 09:42 AM
was

Please see output below: Why is there considerably more activity on RB1 compared to the rest? Can someone please explain the stats to me, or at...

David Brent

07-13-2004 09:11 PM
Ana C. Dent

Hello -- I am trying to optimise a JDBC connection and an Oracle 9i database for reading millions of records at a time to a 1 Gig PC running...

Howie Goodell

07-13-2004 08:40 PM
Jim Kennedy

Hi, On my first oracle instance, I have a global type 'productarray' (CREATE OR REPLACE TYPE productarray AS TABLE OF VARCHAR(30)), I have a package...

Steph

07-13-2004 11:43 AM
Mark D Powell

when i run the statement: SQL> select rowid from student_semester; ERROR at line 1: ORA-01445: cannot select ROWID from a join view without...

tracy

07-12-2004 11:55 PM
kaapie

I have a web page that connects to oracle 8i via .net and get a "could not resolve TNS service name" when I try to connect. what am I doing wrong? to...

nadsie

07-12-2004 08:06 PM
nadsie

I have talked to Oracle customer support and they tell me that i cannot order un-supported software anymore. I have even searched on Ebay to see if...

Ali Zaidi

07-12-2004 12:20 PM
Ali Zaidi

New to oracle, but I'm coming from the sybase side. I took over one of our oracle production databases (1.5 Tb) while the regular dba is out. I got...

gecho

07-12-2004 10:28 AM
Mark D Powell

Hello, I am using Oracle 10g and have configured OEM grid control. I am searching for some tool like Capacity Planner which was present in Oracle 9i...

Shailesh

07-12-2004 05:46 AM
Shailesh

in Ingres I can do this update table1 from table2 set table1.field = table2.field where table1.id = table2.id is there an equivalent in Oracle...

michael newport

07-12-2004 02:07 AM
michael newport

Hi, I have installed oracle9i(9.1.0.1.0) in win2000 (single pc). I want to create a new database manually . If anyone willing to help me it will...

oracle

07-11-2004 11:19 PM
Hans Forbrich

bsc7080mqc (AT) mylxhq (DOT) com wrote: Have you looked at Oracle's Workflow functionality? That shows a number of tricks, especially related to...

Jack Parker

07-11-2004 06:07 PM
Hans Forbrich

A weird issue...though hopefully not for everyone... I am trying to connect to a 10g database on a Red Hat Linux server from my 9i client on a XP...

Chris

07-10-2004 10:16 AM
Chris

Hi guys - I have a weird condition here I'm trying to get resolution on, and unfortunately I'm not getting anywhere with my friends at Oracle. I'm...

Dan Loomis

07-09-2004 10:22 PM
Dan Loomis