I am trying to run the following query: Select min(tran_date) from Sales WHERE (Card1 = '123' OR Card2 = '123' OR Card3 = '123' ) and product =...

Kevin

07-16-2003 08:35 AM
Kevin

Hi all, I have a table with 18m rows in a data warehouse. 3 m rows have a '-1' value and 15 m rows have mostly distinct values. Is this a good...

jabs

07-16-2003 07:30 AM
jabs

Jenny Wang wrote: SELECT object_name FROM all_objects WHERE object_name LIKE '%PRIV%'; The source of all knowledge is there. -- Daniel Morgan

Daniel Morgan

07-16-2003 05:27 AM
Pete Finnigan

on second thought, it seems more useful to get into the developer side .... my understanding is that most DBAs first spend at least a couple of years...

MM

07-15-2003 03:28 PM
Daniel Morgan

gabsaga_tata (AT) hotmail (DOT) com (Taji) wrote in Try something like the following. %3 is the owner and %1 is the tablename. This does not do...

Billy Verreynne

07-15-2003 02:59 PM
Taji

"Ilia" <nospam (AT) deathtospam (DOT) com> wrote what platform is your client on (the machine that runs the java and prints out your String val). ...

bung ho

07-15-2003 12:42 PM
bung ho

Hi all, Hope you can give me a hint of what to be looking for here. We've got an Oracle ODBC connection that we just set up this morning and...

Hypermommy

07-15-2003 12:13 PM
tojo

Hi everybody, i have a very strange problem. Please give me few minutes to explain you the situaton. I have a DB Oracle 9i Enterprise Edition running...

roberto santinelli

07-15-2003 11:17 AM
roberto santinelli

At the risk of asking an obvious question have you tried format() ? I have been doing a bit of VB<>mySQL and its mySQL dates are non VB friendly...

mpduncan02

07-15-2003 10:33 AM
bmcdonald27

I have a dmp file for my database SID=test. I have export the database for user "owner". So do I need to create "test" database and user "owner"...

myhome

07-15-2003 10:32 AM
Mark D Powell

Is there anyway of eliminating duplicate entries as the database loads data using SQLLDR and/or .ctl (Control File)? I use the following command...

gilgantic

07-15-2003 10:13 AM
tojo

I would like to live in your world :-) "Niall Litchfield" <n-litchfield (AT) audit-commission (DOT) gov.uk> escribió en el mensaje...

Loinex

07-15-2003 07:53 AM
PedroF

Hi there, I got problem when installing the Oracle 9iAS Infrastructure Release 2 (9.0.2.0.1) on a Windows 2000 server (SP4). The installation...

Eric Leung

07-15-2003 12:55 AM
Ashish Awasthi

Karsten Farrell <kfarrell (AT) belgariad (DOT) com> wrote <snipped for brevity> Hi again, Karsten, I've got a bit of a follow up on this but...

Hypermommy

07-14-2003 05:31 PM
Karsten Farrell

Kin Ng wrote: c.d.o.marketplace ... things you are buying or selling c.d.o.server ... things related to Oracle RDBMS server c.d.o.tools ... things...

Daniel Morgan

07-14-2003 03:04 PM
Kin Ng

hi, does anybody know an alternative resource for the scripts needed to set up a region database,especially for the 'namesini.sql'-script. i've got...

lester psigal

07-14-2003 11:15 AM
lester psigal

Hi all, Does anyone have some sample VB code (simple is good) that access an Oracle9i database? The demo tables for Scott is just fine. I'm trying...

Angie

07-14-2003 01:57 AM
Jim Kennedy

So is this to say that your brain can calculate the following: (ln(pi^1/4))^2/3 just as accurately as a calculator? Just kidding... LOL, Brian

Just_Buy

07-14-2003 12:23 AM
Galen Boyer

hi where i can find a documentation for sqlplus and plsql thx uruz

uruz

07-13-2003 09:05 PM
uruz

Hi everyone, can anyone suggest a solution for problem : How can we in ON-ERROR trigger make some action (for example to go to some block, requery...

mark

07-13-2003 07:06 PM
Daniel Morgan

Hi! Everyone: I am trying to use "Backup" from Backup Management within Oracle Enterprise Manager Console, but everytime it pops up error message...

PGVin

07-13-2003 01:24 PM
Hans Forbrich

Hi, i need solution for that message in oracle forms, but through trapping in ON-ERROR trigger. How can we in on-error trigger make that program goes...

marc

07-13-2003 11:29 AM
Sybrand Bakker

has anybody had experience creating an execute file setup.exe for installing Oracle Forms/Reports/Graphics RUNTIME? I want to install the RUNTIME of...

Jaz

07-13-2003 07:49 AM
Jaz

Can someone tell me what's wrong with my use of the WITH clause? with summary as ( select brand_code from tblmasters where created_by <...

Kin Ng

07-12-2003 03:09 PM
Kin Ng

hi if i try to launch the management console or connect to the ora8 database i get the error no listener installed. what means that thx martin

m.pfeffer

07-12-2003 01:56 PM
Sybrand Bakker

"Sybrand Bakker" <gooiditweg (AT) sybrandb (DOT) demon.nl> wrote I don't believe this to be true (at least in 9i). At least it ought not to be...

Bliss

07-12-2003 11:14 AM
Niall Litchfield

Hi Rüdiger you can do it with "execute immediate" execute immediate 'SELECT count(*) FROM '||r.tablename into rows; execute immediate 'UPDATE...

Dirk Tschentscher

07-12-2003 07:53 AM
Rene Nyffenegger

Hi, I have a SQL script which contain SQL statements very similar to the example below that create and modify a number of tables. The SQL statement...

Jon

07-12-2003 01:15 AM
Tim X

I have a windows 2000 machine. I want to install Oracle9iAS release2 on my machine without being on a network or the internet. My machines name...

mel finney

07-11-2003 08:21 PM
Anna C. Dent

padderz <member633 (AT) dbforums (DOT) com> wrote padderz is right. forgot abotu the index by binary integers and didnt realize you were using two...

Simon Davies

07-11-2003 11:18 AM
Ryan Gaffuri

On 10 Jul 2003 12:32:05 -0700, datavector (AT) hotmail (DOT) com (Ken Chesak) wrote: Not sure why you aren't simply compiling those procedures as...

Sybrand Bakker

07-11-2003 09:54 AM
Ken Chesak

Interestingly using NOCOPY compiler hint here would cause OUT parameters to be populated, for example... Connected to: Oracle8i Enterprise Edition...

padderz

07-11-2003 08:06 AM
padderz

Hallo *, we got a problem under oracle 7.3.4.4.0. The following problem we have: We have two db-scheme (scheme1, scheme2). In scheme1 we use...

stan

07-11-2003 07:48 AM
stan

On Wed, 9 Jul 2003 17:17:58 -0400, "Kay Cee" <cee.1 (AT) osu (DOT) edu> wrote: SELECT item_no, date FROM tablename x WHERE date = (SELECT...

Sybrand Bakker

07-10-2003 05:08 PM
Niall Litchfield

"P. Griffioen" wrote: SELECT ... FROM ... WHERE ... AND ... AND ... AND ...

Daniel Morgan

07-10-2003 04:05 PM
Daniel Morgan

Hi gurus, I have 3 tables as follows: 1) Buyers: BuyerID 2) Sellers: SellerID 3) BuyersSellers: BuyerID, SellerID, GoldorSilver Where GoldorSilver...

SPIDERMAN

07-10-2003 11:55 AM
Daniel Morgan

Hi, I just need free e-course materials for Exam #1Z0-001 Introduction to Oracle: SQL and PL/SQL. In which site I have to go & download the course...

sowmyas

07-10-2003 07:57 AM
sowmyas

hi i installed oracle8 on a w2000 advanced server. First time i will be asked for Administrator password Management Server What means management...

m.pfeffer

07-10-2003 06:24 AM
Niall Litchfield

I need to detect when an insert fails due to a server being down. I have the following code (most of it snipped, names changed to protect the...

Roger Moore

07-10-2003 05:29 AM
Billy Verreynne

To help you You can use "Oracle Tool" on http://membres.lycos.fr/pmscontact/ This tool tell you how tablespaces are used and to the tables/db objects...

Rath.Yelandur

07-10-2003 04:58 AM
philippe

I have developed a VB application that uses Oracle 8i database for backend. The database server is on the local network. From my development...

Alex

07-10-2003 04:49 AM
Billy Verreynne

"Steven Robinson" <srobinson (AT) turtlefur (DOT) com> wrote Posts along the lines of 'ALTER TABLESPACE ......' are assuming that you are using...

Niall Litchfield

07-10-2003 03:06 AM
Guido Konsolke

OK. Here's an update. I used this trigger: CREATE OR REPLACE TRIGGER UZBMETRSYNC AFTER INSERT OR UPDATE OR DELETE ON UZB1.UZBMETR BEGIN IF INSERTING...

Paul Murphy

07-09-2003 08:51 PM
Joel Garry

"Donald Thompson" <dlt (AT) checkmysigforemail (DOT) com> wrote A valid backup and all the archive logs from that time to the time of the crash...

Donald Thompson

07-09-2003 06:18 PM
Joel Garry

I have been playing around with materialized views and I have created one that simply views a table on a remote database. It works fine, but I...

JamesLane

07-09-2003 06:05 PM
Sybrand Bakker

I'm trying to call a stored procedure via sqlplus, and keep getting a "wrong number of types or arguments in call" error. I've been up and down this...

chess hazlett

07-09-2003 11:24 AM
chess hazlett

Hi, I need to create a program that sets up the necessary server code in the database by running various scripts. It now works for...

TimMcConechy

07-09-2003 10:27 AM
TimMcConechy

i'm using oracle 9i i need to use dates in my database, but i encountered some problems (the language has bit differences with standard sql..). so,...

jdk

07-09-2003 10:05 AM
Jim Kennedy

"Frog" <FrogRemailer (AT) bigfoot (DOT) com> wrote absolutely he mouths off in public before thinking. For some reason that seems to remind me of...

Niall Litchfield

07-09-2003 03:53 AM
Niall Litchfield

Hi Can anybody advise what is the best route to do this. Joz

Jozua

07-09-2003 01:49 AM
Jozua