Hi All, apologies for trivial question...but i need help.. it is possible to run few oracle databases on a single machine...how can I enumerate a...

schw

11-13-2006 08:42 PM
Renzo Zagni

Hello! I need to know the length of the execution of an SQL statement in Oracle SQL worksheet. I know there is a command to set a flag on but I do...

Norbert Pürringer

11-13-2006 01:22 PM
Mark D Powell

Idem. Thanks in advance, Jose Luis.

jose_luis_fdez_diaz

11-13-2006 10:55 AM
jose_luis_fdez_diaz

Looking for ideas: Need some data (within Oracle/Lnux) from SQLServer(2K) on a CONTINUAL basis. Does NOT need to be Real-Time...can be like Mat....

klabu

11-12-2006 10:23 PM
Michael Austin

Any ERwin people here ? Does ERwin (4.1.4) let you specify PK Constraint name ? How ? Thanks

HNN

11-11-2006 11:10 AM
Galen Boyer

Can anyone suggest a newsgroup or something similar to assist in a Peoplesoft 8.8 question? Thanks! Tony Miller Monroe, WA --

tony_becky_mikey_verizon_news

11-11-2006 12:33 AM
tony_becky_mikey_verizon_news

JDBC connection problem: The name of the database is HR. The server is localhost The default port is 1521 (or so I'm told). The user name is...

ddog

11-10-2006 04:56 PM
ThomasO@cpas.com

Greetings, No of records in TABLE1 = 46697622 No of records in TABLE2 = 9433275 No of records in TABLE3 = 9576297 SELECT ...

pankaj_wolfhunter@yahoo.co.in

11-10-2006 03:45 PM
Charles Hooper

I have a query with an inline view aliased as 'x'. When I run the query, it takes hours. If I take the inline view out, throw it into a temporary...

Mike C

11-10-2006 11:22 AM
Mike C

Hi all. (Oracle 9i2) I have a name column that up to now had a unique index+constraint to prevent the same names. I wanted to change this, so that...

Martin T.

11-10-2006 09:45 AM
Mark D Powell

Hi, I'm a complete Newbie when it comes to Oracle so please excuse my simple questions. I have installed Oracle 10g Express on my home system and so...

Ade

11-09-2006 06:55 PM
DA Morgan

I am trying to write a server using OCI. The server uses one username/password for all clients. I can set up on service context and support multiple...

faceman28208@yahoo.com

11-09-2006 12:05 PM
faceman28208@yahoo.com

Hi. I am developing a web application (with ASP.NET, framework version 1.1) which has to run some queries on a Oracle server (version 9.2),...

hashintosh

11-09-2006 11:41 AM
hashintosh

Hi, I'm trying to test the oracle snapshot but failing to do so. I have a test database with a table called RT_MANUFACTURER. I created...

enigma

11-09-2006 11:30 AM
DA Morgan

Hello Friends, I have inherited a vendor supported database. Environment is : ORACLE V8.1.7.4.1 - Production vsnsta=0 vsnsql=f vsnxtr=3 Windows...

Tam OShanter

11-09-2006 05:59 AM
Vitaliy Vorontsov

Hello, I want to compare two LONG columns in a specific table (Oracle 8i). Maybe by the CRC code for the LONG column. Is there any function that...

Eitan M

11-08-2006 05:37 PM
Oliver Stratmann

Hi, Could someone please recommend books on Oracle Forms and Oracle Reports. I am new to Oracle and would like to develop a simple forms...

comp.databases.oracle.server

11-08-2006 12:02 PM
DA Morgan

Does anyone have any sample code of how to bind simple arrays (i.e. TABLE OF INTEGER) to a PL/SQL anonymous block via OCI? I've tried loads of...

Christian McArdle

11-08-2006 05:54 AM
Christian McArdle

Hi all, When doing either of these operations in 9i: create table x as (select * from y); insert into x(a,b,c) (select a,b,c from y); ....does...

Tarby777

11-07-2006 11:36 AM
EscVector

Hello, I'm trying to run under OCI for C/C++ something like: where 'to_date...' is a variable. How Can I do this. I've been testing several (wrong)...

albert.medela@gmail.com

11-07-2006 11:12 AM
Andy Hassall

How do I add a existing column to a composite key in an index organized table on Oracle 9i? create table mytable ( mycol1 number, mycol2...

Prasath

11-07-2006 06:31 AM
purush

All: I'm attempting to write a value into a Blob. The database is Oracle 8.0.6, and I've installed the ODAC 9.2.0.7.0. I'm calling this from...

Terry

11-07-2006 02:19 AM
Frank van Bortel

Hi, I have written a trigger on a server say server2 as below and is working fine,but here i am using empty_blob(),and in server2 i am inserting...

Shiv

11-06-2006 01:12 PM
DA Morgan

Greetings, The requirement for COL1 is "sum of number of distinct link group by badge where quote in 1,2,3,4" and requirement for COL2 is "sum of...

pankaj_wolfhunter@yahoo.co.in

11-06-2006 01:10 PM
DA Morgan

Hello all, I would like a way to copy the data from l_txt to vc_txt with sql*plus. create table test (pk char(6), vc_txt varchar2(2000), l_txt...

Peter Keckeis

11-06-2006 08:48 AM
Martin T.

I was trouble connecting to my Oracle database and they asked me to check the environmentatl variables. On an NT machine are these settings in the...

mike

11-06-2006 04:52 AM
gazzag

Hi all, When doing either of these operations in 9i: create table x as (select * from y); insert into x(a,b,c) (select a,b,c from y); ....does...

Tarby777

11-06-2006 04:18 AM
Tarby777

Hi all, When doing either of these operations in 9i: create table x as (select * from y); insert into x(a,b,c) (select a,b,c from y); ....does...

Tarby777

11-06-2006 04:18 AM
Tarby777

Dear group, We have lists. Each list has thousands of ordered lines. Lists are implemented with the usual master/detail tables. An operation O may...

hasta_l3@hotmail.com

11-05-2006 12:56 PM
DA Morgan

V10.2.0.2 Linux Long story to which I'll spare everyone the details. Database is open, but reports 40 or so missing files. How do I convince Oracle...

Ana C. Dent

11-04-2006 08:11 PM
Frank van Bortel

Greetings, First up, I'll genuflect in front of all you gurus here and humbly beg forgiveness: I'm trying to debug somebody else's code, and...

jpatokal@iki.fi

11-03-2006 04:18 PM
Robbert van der Hoorn

Hi Gurus, I am looking for a stored procedure or package to find total number of rows in each table in a schema. Something like, you can pass the...

janu

11-03-2006 03:03 PM
Mark D Powell

Hi I have a plsql stored procedure that takes a blob as input parameter. I have to insert this parameter into a table. What's the best practice to...

jaft

11-03-2006 11:29 AM
DA Morgan

Hi, I have a problem.I have two servers, server1 and server2.i want to create a trigger in a server1 in a table so that when there is any...

Shiv

11-03-2006 03:55 AM
Frank van Bortel

Hi, The version is Oracle 9i.I am sorry to say that there was some mistake in mentioning my problem.There are two different problems at two different...

Shiv

11-03-2006 12:21 AM
Shiv

I'm a student studying oracle 10g backup/recovery strategies and I was hoping someone could tell me the steps in restoring/recovering a lost datafile...

OklahomaDave

11-02-2006 09:33 PM
Brian Peasland

Hi, My first table has the following snap shot. Uid is a GUID Since Uid is a GUID , i did INDEXING and thats how i got idx 1,2,3.... dName Addr...

ganesh

11-02-2006 11:55 AM
DA Morgan

Hi, I installed OracleExpress on a windows 2003 server. Right after the installation, I was able to create and use a database. Then, after the first...

Mathijs

11-02-2006 10:39 AM
Mathijs

Hello all, I would like a way to save the results of a query to a table, from within a transaction, and then when I role back the transaction,...

dean

11-02-2006 08:37 AM
dean

Hi, I have SQL query, that I'm trying to tune up. If I simplify it, I can say: When I run my select statement, where I'm calling function (that is...

Tomeo

11-02-2006 04:36 AM
Martin T.

Hi, I the parameters in the commandstring never get substituted for. So I end up sending an invalid sql statement over to the oracle db. Apparently...

sherifffruitfly

11-01-2006 08:52 PM
sherifffruitfly

Having been forced to give up my OCILogon call to support transactions and non-blocking I/O, could someone tell me what OCIAttrSet call I would use...

faceman28208@yahoo.com

11-01-2006 06:01 PM
Andy Hassall

Hi All, I'm doing a silent install for Oracle 10g. So, I'm using a response file. I've been looking for some decent documentation on how to...

amerar@iwc.net

11-01-2006 10:56 AM
amerar@iwc.net

Hello. When doing an insert via a stored procedure, I get the following errors: ORA-21000: error number argument to raise_application_error of...

topher67

10-31-2006 09:50 PM
Jim Kennedy

A Nashville client has an immediate requirement for an Oracle PL/SQL Developer for a 6 month Contract-to-Hire position. The Developer will be the...

pyramid36

10-31-2006 04:41 PM
Ed Prochak

righty, after a bit of investigation I found a solution. I have take tom kytes code from...

Kevin

10-31-2006 12:44 PM
Kevin

I understand that Oracle 10g will rewrite your CURSOR FOR LOOP statements into a BULK COLLECT statement. I am contemplating no longer explicitly...

chris

10-31-2006 12:04 PM
DA Morgan

I'm having an issue with an outer join query that I'm hoping someone can help me with. I have 3 tables; Emps, Quals, and an XRef table. I want to...

drvice@nppd.com

10-30-2006 11:12 PM
drvice@nppd.com

Hi, First, i'm a newbie with sql and i would like to do the following: I want to extract a random sample for each value of a certain field in a...

PMDORAIS@gmail.com

10-30-2006 03:50 PM
PMDORAIS@gmail.com

Hi, when I want to log in to the EM I'm getting the following error: This OC4J is configured to make JMX connections via RMIS and fall back to RMI...

vartan@o2.pl

10-30-2006 10:46 AM
vartan@o2.pl