I have a Table without a primary key and want to add a primary key. The problem is: how to update the existing columns with unique number values? I...

Ralf Zwanziger

07-02-2003 10:44 AM
Daniel Morgan

gelewyc (AT) nyct (DOT) com (george lewycky) wrote in message news:<68aecc05.0307010652.55aa20dc (AT) posting (DOT) google.com>... George, Usually...

george lewycky

07-02-2003 10:11 AM
Alex Filonov

Hi, I didnt expect that my little query would spark off such a discussion on the topic. It feels nice to see people discussing on the same. I know...

aruneeshsalhotr

07-02-2003 09:40 AM
aruneeshsalhotr

On our company we wrote a very complex ERP. All our jurassic program have to replace, with something more modern. On my country (Italy) "Oracle...

Ferro

07-02-2003 08:56 AM
Ferro

Hello ALL, I have created an Oracle 8.1.7.3 database instance with NLS_NCHAR_CHARACTERSET=ZHS16CGB231280 (for supporting Simplified Chinese) and I...

BillLi

07-02-2003 01:26 AM
BillLi

Hi I have a full exportfile xx.dmp from my 8.1.5 database and I want to upgrade to version 9i using Enterprice manager. How shall I do? I dont want...

Roger

07-01-2003 11:34 PM
Rauf Sarwar

I'm going to an interview for a PL/SQL developer position. It's been a little while since I've worked with PL/SQL, so I'm wondering if anyone...

Cynic

07-01-2003 07:25 PM
Joel Garry

We have performance problems with a complex system. We use a compaq proliant double-processor with a Raid-5 System and Win2000 as database server,...

Georg Walk

07-01-2003 05:45 PM
Scott Richardson

Hi, I have several process which do INSERT into the same table (no index, no constraints). I was wondering if insert statements were treated "at...

Francois Berger

07-01-2003 01:10 PM
Daniel Morgan

"Francois Berger" <berger (AT) fire (DOT) shacknet.nu> wrote If you do the insert once as opposed to n times it should always be faster, in...

Niall Litchfield

07-01-2003 01:09 PM
Daniel Morgan

In article <fc071652.0307010551.702b1b7 (AT) posting (DOT) google.com>, seanhennessy (AT) eircom (DOT) net says... Did you include the schema name...

tojo

07-01-2003 12:50 PM
DJ

Posted and emailed: Daniel Frechette <daniel (AT) multipro (DOT) ca> wrote: bought the "Oracle9i JDeveloper Handbook" published by Oracle...

David Segall

07-01-2003 09:21 AM
David Segall

Hi, I have some queries regarding migration of Forms 3.0 to Forms 6.0..I am sure some one out there will be able to help me out.. 1. Can Forms 3...

shery mathew

07-01-2003 07:44 AM
Tiago Rocha

I have these two tables Calendar (rows are pregenerated for every day) DATE DAY ============ 1.5.2003 Th 2.5.2003 Fr 3.5.2003 Sa ....

JN

07-01-2003 05:03 AM
andrewst

Hi! My query doesn't answer like would be. This is the code: s=string(today(),'dd/mm/yyyy')+' 08:00' SELECT COUNT("ID_KEY") FROM...

Paola

07-01-2003 04:27 AM
Paola

Hello everyone, I've R'ed the FM, and I've S'ed the FW, and I'm still unable to come up with a solution to what seems like a fairly simple problem. ...

Michael B. Klein

06-30-2003 05:42 PM
Michael B. Klein

On 30 Jun 2003 15:16:45 GMT, revjack <revjack (AT) revjack (DOT) net> wrote: Scroll down to Example 3 in the PL/SQL Examples part of the...

Andy Hassall

06-30-2003 04:08 PM
Andy Hassall

mallika wrote: alt.test Please don't do your laundry here. -- Daniel Morgan http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp

Daniel Morgan

06-30-2003 03:35 PM
Daniel Morgan

I have a database in Oracle 9i. I want to backup the structure and data in some *.sql file. Can sqlplus do this purpose for me?? and How to do? Thx

myhome

06-30-2003 09:57 AM
Rauf Sarwar

hi - i am trying to load a flat file where the fields are defined as either char (40), char (50), and date. The oracle database is also defined as...

Val

06-30-2003 06:22 AM
Guido Konsolke

This is an easy way to update a table from a second table in Sql Server. update table1 set table1.col2 = table2.col2 from table1, table2 where...

Greg

06-30-2003 05:15 AM
programmer

I am new to Oracle (except for a little pl/sql knowledge) Could someone let me know how many levels of security/authentication Oracle 8i (or 9i)...

SPIDERMAN

06-29-2003 02:48 PM
SPIDERMAN

Could someone tell he how to use plsql to get multiple counts from a table I want to get record counts for consecutive weeks. how could i do output...

Peter Verschueren

06-29-2003 02:21 PM
Ed Prochak

Mike Smith wrote: That sounds about right. Well it is Pro*C not ProC++. And besides, what methods are you going to put for you embedded SELECT...

Ed Prochak

06-28-2003 05:28 PM
Ed Prochak

I need help, my situation is the following, I transate SQL the ORACLE to POSTGRES, and i a big problem: In oracle--> SELECT * FROM esc_usuarios, ...

Marcos Medina

06-28-2003 03:56 PM
askot@ut.ee

Hi All, Could anyone post some good links for using a database (Oracle) on a web site? Thanks in advance for your help! Silviu

silviu

06-28-2003 10:55 AM
Oradba Linux

Hi, Is there an expert out there that can help me resolve an issue with a query. I am joining several columns to a PERIOD dimension, which contains...

Fernando Sanchez

06-28-2003 10:20 AM
Fernando Sanchez

"Rudi" <rschoebel (AT) hotmail (DOT) com> wrote Not very likely. Never seen any problems with archivelogs, your problem is definitely pointing to...

Rudi

06-28-2003 04:15 AM
Sybrand Bakker

Daniel Morgan (damorgan (AT) exxesolutions (DOT) com) wrote: : Malcolm Dew-Jones wrote: : > Daniel Morgan (damorgan (AT) exxesolutions (DOT) com)...

Uma Muthu

06-28-2003 02:51 AM
Malcolm Dew-Jones

Thank you. your tips did help. "Anurag Varma" <avarmadba.skipthis (AT) yahoo (DOT) com> wrote

Ashwin

06-27-2003 07:42 PM
Ashwin

I'm going to try to answer all question. My oraclcle is 9i version I added in my ini.ora the line : utl_file_dir=P:\shared...

s Lehaire

06-27-2003 03:24 PM
Daniel Nichols

you can also look on your server machine for sqlldr.exe start > programs > command prompt then cd to your directory with the data you must run it...

george lewycky

06-27-2003 12:31 PM
Sybrand Bakker

Just a note. This problem manifests itself in Selects and Inserts as well as fetches. We were able to work around the problem by using a...

ppmyers

06-27-2003 09:59 AM
ppmyers

Hi Gods of Oracle, I'm in need of something like: select * from colourtable where colour in :somecolours Obviously :somecolours would be...

Jack

06-27-2003 09:25 AM
Niall Litchfield

Ok, folks. Here's the deal. Basically, I have a Stored Procedure in Oracle that inserts data into a table. Simple enough. I want to call this sp...

Jason

06-27-2003 08:54 AM
Billy Verreynne

"koert54" <nospam (AT) nospam (DOT) com> wrote More opinions/reviews about "Art and Science of Oracle performance Performance tuning " will be...

Petee

06-27-2003 08:10 AM
michael ngong

I need help, my situation is the following, I transate SQL the ORACLE to POSTGRES, and i a big problem: In oracle--> SELECT * FROM esc_usuarios, ...

Marcos Medina

06-27-2003 07:59 AM
Marcos Medina

Hello. I'm having trouble importing images. I have the following procedure : declare Image ORDSYS.ORDImage; ctx RAW(4000) := null; begin insert...

lars-jacob hove

06-27-2003 07:52 AM
lars-jacob hove

Apparently, your problem is the results of the PL/SQL procedure is not displayed. Don't forget to use SET SERVEROUTPUT ON before the PL/SQL block (it...

JDC

06-27-2003 12:28 AM
Stéphane LEJAY

Andy Hassall <andy (AT) andyh (DOT) co.uk> wrote You are right...I am running within a SQLPLUS session Yep From TOAD I copied the following...

Ecce Nihil

06-26-2003 06:22 PM
Andy Hassall

On 26 Jun 2003 00:18:32 -0700, usenet (AT) sein (DOT) sportwetten.spb.ru (Oleg Paraschenko) wrote: The above syntax definitely IS ANSI-syntax. Why...

Sybrand Bakker

06-26-2003 03:38 PM
Sybrand Bakker

Andy, I changed the column to long varchar and everything worked fine. The Unix guys did the build I will check with them about the Oracle...

Ken Chesak

06-26-2003 01:14 PM
Andy Hassall

Hallo, ich selektiere mit SQL aus einer Oracle9i DB daten als XML-Stream. Nun möchte ich diese Daten mittels HTTP-Post an einen anderen...

Robby

06-26-2003 12:28 PM
Robby

Has any experienced the following error when upgrading from Oracle8i to Oracle9i and running a 'batch' SQL Loader...

R. Hutchinson

06-26-2003 10:26 AM
Hans Forbrich

"Jérôme VUIBERT" <jerome.vuibert (AT) fleximage (DOT) fr> wrote Brian's suggestion wasn't in fact to use the compress option (which rejigs storage...

Sybrand Bakker

06-26-2003 10:03 AM
Niall Litchfield

Thanks Daniel, I've worked at companies and done the bend over bit. It hurts. Worked at one company where they would not hire support people....

Jim Kennedy

06-26-2003 09:50 AM
programmer

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