Hi, Is it possible to concatenate multiple rows of data in a single select statement. For example, if my table was FIELD1 ------ aaa bbb ccc

D. Alvarado

06-26-2003 09:28 AM
programmer

hello first off I am taking a course on Database Modelling with little emphasis on triggers and/or stored procedures so dont percieve that this is...

dave m

06-26-2003 09:10 AM
Rauf Sarwar

"Jaret Lafoudravecmonhnez" <toto (AT) toto (DOT) com> wrote Prepare a drop script for the procedures; run the export; perform the import; and then...

Mark D Powell

06-26-2003 03:56 AM
Jaret Lafoudravecmonhnez

Hi, I compiled a report (ver 6i) using NSL_LANG as CROATIAN_CROATIA.UTF8, because I needed russian characters.On clients with XP everything worked...

Nenad

06-26-2003 03:19 AM
Nenad

Ryan Gaffuri wrote: If it has value ... yes. To be a physician requires a college degree, an internship and a certificate. To be an attorney...

Daniel Morgan

06-25-2003 06:18 PM
Daniel Morgan

Anurag Varma wrote: The point of my demo ... and the point of my comments here ... is not to influence people to write code one particular way or...

denaro

06-25-2003 04:53 PM
Anurag Varma

Hey, I'm last year student Informatics at an university. My project for my graduation consist of building an Oracle database and making a Java...

Jibe

06-25-2003 02:41 PM
Rauf Sarwar

We are looking for Oracle Applications 11i (or 10i) HR module technical developers in the Washington DC area. At least 2 implementations experience...

rravella

06-25-2003 02:18 PM
rravella

I am trying to upgrade my OCP 6/6i application developer certification to 9i. I want to find any books or training materials. Any information will...

JoAnn

06-25-2003 02:16 PM
Ryan Gaffuri

Hi All {Platform Win2kPro and Oracle8i), I am having some problems with executing dynamic sql from within a function. If i copy the code into...

Adam C

06-25-2003 09:51 AM
Greg Forestieri

Hi all, In a gnu/linux envrionment, my code does a multithreading ( not oci) db requests processing via a connection pool. The problem is that there...

Sam

06-25-2003 09:31 AM
Sam

Sybrand Bakker wrote: I wouldn't repost the same question if already answered. The first time I had asked about version 8i, and the second time I...

Holger Peine

06-25-2003 12:30 AM
Holger Peine

Just some closure on this, In the end I finally was able to come up with the sql statements that did the work for me, and I didn't need to use any...

Adam C

06-24-2003 07:40 PM
Adam C

On Tue, 24 Jun 2003 08:20:46 -0700, Daniel Morgan <damorgan (AT) exxesolutions (DOT) com> wrote: Its is not Homework. I need it really. Oracle...

stan

06-24-2003 01:20 PM
Daniel Morgan

TM wrote: Put in other terms ... DB2 has no security unless one purhases Tivoli or other products in addition to the database. Every product has...

Daniel Morgan

06-24-2003 01:13 PM
Xpressy

Mark, Don't rely on the implicit string to date conversion. Explicitly convert it. eg AND reportdatentime >= '25-Mar-2003' AND reportdatentime <...

Jim Kennedy

06-24-2003 09:52 AM
MThomas

OCI can be faster than pro C if written properly. Why one would use multiple connections is beyond me. The problem with multiple connections...

Jim Kennedy

06-24-2003 06:57 AM
Jim Kennedy

Using Oracle 8i We have a report server which runs a bunch of reports for a bunch of clients. The reports and various info about each report are...

Tony

01-13-2003 05:05 PM
Tony

"Frank" <fbortel (AT) home (DOT) nl> wrote I put it into .profile but nothing change, always the same error.

Seb

01-13-2003 04:13 PM
Seb

There are implementations of SAP system on IBM's DB2, too. Best regards, Ognjen Antonic - Ogo

Ognjen Antonic

01-12-2003 04:41 PM
DA Morgan

HI, I want to know how to return a resultset in a proc which must be received in a Java servlet Thx for responses

s Lehaire

01-10-2003 11:17 AM
DA Morgan

"aurum" <alz72 (AT) rambler (DOT) ru> wrote external procedures run from the server *ONLY* sorry Sybrand Bakker Senior Oracle DBA

Sybrand Bakker

01-10-2003 01:07 AM
aurum

We currently running 8.1.6.3 patch 8 on Win2K Adv. Srv. SP2. Hardware is compaq quad 900 MHz and 8GB RAM We are able to use more than 4 GB RAM with...

Neil

01-09-2003 09:45 PM
Dan Yusuph

Do you have permissions to modify omsconfig.properties - which is where the encrypted credentials are stored. Also check the Enterprise Manager logs...

James

01-09-2003 09:48 AM
James

Is this any help? http://otn.oracle.com/products/bi/pdf/o9ir2_compression_twp.pdf -- Niall Litchfield Oracle DBA Audit Commission...

Niall Litchfield

01-09-2003 04:36 AM
Cesar Otero Souto

Hi to all: First of all, sorry for the crossposting, but I was not sure where should I put this message. I need the OCI Library files to compile an...

john smith

01-08-2003 06:18 AM
john smith

Hi. In the project I'm working on now each developer have its own user account towards the database. The application we are doing generates logging...

Helge Hauan

01-08-2003 05:19 AM
Jim Kennedy

There are several FAQs about the Oracle database scattered around the Internet, and many ways of finding answers to the simpler questions about...

Jonathan Lewis

01-06-2003 01:36 AM
Jonathan Lewis

I tried installing nt817personal on my Gateway Windows XP Pentium 4 laptop. It wouldn't install so after searching google, I renamed...

Keith A. Jakubowski

12-27-2002 06:45 PM
Keith A. Jakubowski

Hi there, Has anybody here successfully installed Oracle 8i ( release 3 ( 8.1.7 ) ) on Solaris x86 version 8 ? I am confused ( among other things )...

frederick smith

12-22-2002 01:51 PM
pheonix1t

Thanks for the reply. My primary objective is to query SQL Server on demand. I agree it would be infinitely easier to send the data from SQL to...

Timbo

12-20-2002 09:49 AM
Timbo

I received this error message when I was running my package.procedure to access a remote database view -- via a database link -- on one database to...

Scott

12-20-2002 07:41 AM
Scott

kellywh (AT) hotmail (DOT) com (oranewbie) wrote: Are you sure there are no triplicates or higher replicates? That query is hosed. 4 opening...

ctcgag@hotmail.com

12-19-2002 01:57 PM
ctcgag@hotmail.com

Jane O wrote: I would like to say that after reading your example twice I understand what you are trying to do ... but I don't. If no one else...

DA Morgan

12-19-2002 11:37 AM
DA Morgan

Hi all, has anybody ever simulated a distributed transaction failure? I would like to make some test, and in order to have the...

Brit Pop

12-18-2002 10:15 AM
Jonathan Lewis

Fri, 13 Dec 2002 15:30:28 -0500, pmatt69 said (and I quote): It's just getting truncated. Check the length of varchar or long output setting in...

Nuno Souto

12-14-2002 07:03 PM
Tim X

hi all, i am using oracle 9.2.0 and i need to create a very large database to accomodate a large influx of data. i have the following two partitions...

B. Kloppt

12-14-2002 05:13 PM
Bert Bear

Any Oracle instance starting after the listener starts will automatically register itself..Do you have instances called galaxy and repo ? Bobby...

TurkBear

12-13-2002 02:04 PM
TurkBear

Comments embedded. Bobby Singh wrote: are missing a closing right paren here. You have 5 left parens and 4 right parens. You need to close the...

Karsten Farrell

12-12-2002 06:45 PM
Karsten Farrell

Hi, I am having problem starting listener with the following listener.ora file on 9i. Listener fails to start with error TNS-01150: the address...

Bobby Singh

12-12-2002 05:50 PM
Bobby Singh

Thomas Kyte <tkyte (AT) oracle (DOT) com> wrote Thanks, Example -> I do select dump(data) from t; I got -> Typ=23 Len=4: 177,68,88,177

Degelis

12-12-2002 10:24 AM
Degelis

susana73 (AT) hotmail (DOT) com (Susan Lam) wrote in message news:<7186ed56.0212102328.77cd2980 (AT) posting (DOT) google.com>... Susan, please do...

Mark D Powell

12-11-2002 12:49 PM
Mark D Powell

I am learning dataGuard 9i, but I can not afford two machines. Has anybody tried to put both instance on the same machine? Will that work? Thanks...

Joe Sath

12-11-2002 02:15 AM
Howard J. Rogers

If I install an oracle database 8i, and created a database with name abc, the system's password is manager. Why I can't use sqlplus as this and log...

Song Zhang

12-10-2002 05:25 AM
Howard J. Rogers

This installation is brand new and not an upgrade of any sort. Its on Linux 8.0 redhat on intel platform. When installing intelligent agent useing...

Bobby Singh

12-06-2002 03:50 PM
Bobby Singh

Hi, I have problem performing full backup of Oracle9i 9.2.0.1.0 under redhat Linux 8.0 kernel 2.4.18-14 on Pentium 4 with 1280 MB RAM. Symptom: 1....

lamshing

12-06-2002 08:05 AM
Yuri Zelenski

Yash wrote: The bulk collect has a "limit" clause, and once collected, obviously a for-all will only process the number of rows in the array. Its...

Connor McDonald

12-05-2002 02:59 PM
Connor McDonald

Posting the error messages (if any) might help. And posting the output from the archive log list would too. Also, I'd like to see the exact...

Howard J. Rogers

12-05-2002 08:54 AM
michael ngong