Hi, I have a table that contains data keys similar the following, where each letter is a key to an address a,b a,c c,b

steve

10-17-2004 06:42 AM
steve

Hello, The book "How to Fail at Software Develoopment" is about all the strange and funny things people do in the name of developing software. I...

arthur@belugalake.com

10-15-2004 10:50 PM
Hans Forbrich

I try to use the Server Data on Insert property to return a column value swhich is set in a trigger. But it does not work. Why not? What am I doing...

Jan van Veldhuizen

10-12-2004 02:14 PM
Jan van Veldhuizen

Hans-Jürgen Schönig wrote: Proprietary. No public API. Details, as they exist, available in the Oracle Networking manuals...

Hans Forbrich

10-12-2004 09:04 AM
Hans Forbrich

Hello everyone, I have many problems when try to connect MSAccess to an Oracle database, do you know how to do this (which ODBC driver, what...

Déian

10-12-2004 08:11 AM
Déian

Am having a problem getting into Enterprise Manager for Oracle 10g - am using same on WINXP Pro, as a learning tool - I am NOT a DBA. I entered my...

William F. O'Neill

10-11-2004 10:25 PM
William F. O'Neill

Is there a function that can calculate number of quarters between date1 and date2? Any info is appriciate it. Gene

Gene Ariani

10-11-2004 08:18 PM
Bricklen

I have an application which is running fine with MS SqlServer, but it should be working with Oracle as weel. At a lot of places we rely upon the ADO...

Jan van Veldhuizen

10-09-2004 09:15 PM
Jim Kennedy

Hi. I'm newto Oracle but want to learn how to make a database and finally use it on my web site. Is there a good tutorial on the Internet somewhere,...

Jan G. Thorstensen

10-07-2004 05:31 PM
Hans Forbrich

Hi, I'm having trouble with implementing some constraints on the database level. An example: --Table A(AID, BID ref. B.BID, ATXT) --Table B(BID, CID...

Agoston Bejo

10-05-2004 10:48 AM
Noons

I just inherited support of this app so bear with me. The scenario: Oracle 9i replicated databases, same C++ server process runs on both boxes. On a...

Will Potter

10-04-2004 09:10 PM
Will Potter

We want to make a query where we check table A for employee numbers and compare that with table B. We would like to build a list of employees who are...

Dale DeRemer

10-04-2004 06:45 PM
Hans Forbrich

Hi all, First off, I'm new to the Oracle world so please be gentle on me. Now down to the problem at hand. I support a CAD application that has an...

Andrew Lowe

10-04-2004 05:50 PM
Andrew Lowe

I know nothing about Oracle forms. A friend of mine said that his firm no longer has the source for many of their applications written using...

Walter Cohen

10-01-2004 08:39 PM
Daniel Morgan

**** Post for FREE via your newsreader at post.usenet.com **** Nathan Sokalski wrote: I am not at work so I cannot play with the function, but...

Mark D Powell

10-01-2004 09:17 AM
Mark D Powell

New to Oracle and having an apparent RI problem in SQL PLus. Ran a script to create some tables. When I began to drop them (this is for a class) one...

ERD

09-30-2004 06:12 PM
ERD

Is this possible in 8 or 9 ? Does anyone have an example ? Thanks

David Pylatuk

09-29-2004 07:54 PM
Hans Forbrich

What wrong with such query: update MY_TABLE set FIELD_ONE = 'A' where FIELD_TWO in (select FIELD_TWO from MY_TABLE where rownum < 11 order by...

Jul

09-29-2004 11:28 AM
Feilone Tong

Hello, I am going nuts. I am trying to connect to my local ORACLE instance using ODBC. It used to work few weeks ago, but it fails now. Connection...

SerGioGio

09-28-2004 12:37 AM
Raju

I just install Oracle 9.2 on my laptop running Windows XP Pro. When I try to connect using the following connect...

jdub

09-27-2004 11:24 PM
jdub

In ASP I am using a connection string that works everywhere in the application, except in Sub Session_OnEnd. There I get the following...

Agoston Bejo

09-27-2004 03:49 AM
Agoston Bejo

Imagine you've got the following situation (Oracle 9i): Table A ------------------- Name Customer Log_Date Log_Type

Wade Williams

09-25-2004 12:11 AM
Wade Williams

In 10g why can I not get a 6 digit millisecond timestamp. Here is my Sql. Select Current_Timestamp(6) from dual; The milliseconds always looks...

ts

09-24-2004 02:23 AM
Dmitry Bond.

Jim Garrison wrote: I found references to one solution, which is to set the table statistics (numrows, specifically) manually...

Jim Garrison

09-23-2004 01:33 PM
Jim Garrison

aloha, i have one question. We have installed oracle DB 9i on server which is running on W2003 server os. Instalation of server was not our...

fake

09-23-2004 10:27 AM
fake

Oracle has a tech article describing how a Java stored procedure can return a REF...

Jim Garrison

09-21-2004 01:27 PM
Jim Garrison

(i am posting here out of sheer desperation... perhaps someone could at least answer me and call me too dumb or something... :}... I have tried...

d.morel

09-21-2004 01:16 PM
d.morel

hi, during a full export of my export of a (Release 9.2.0.4.0 - Production ) database i'm getting the following: I have been thru metalink, and can...

steve

09-21-2004 03:02 AM
agis

Is there any way to reach the content of the DBMS_OUTPUT buffer after calling an Oracle stored procedure from ASP/ADO?

Agoston Bejo

09-20-2004 09:32 AM
Mark C. Stock

I have a question about oracle commit and transactions. Following scenario: Process A performs a single sql-INSERT into a table and commits...

Markus Breuer

09-18-2004 07:32 AM
Mark C. Stock

Hi All I am not a DBA, but a unix administrator. After our DBA's upgraded from oracle 8.0.5 to oracle 8.1.7.4 on our test server, we have noticed a...

Ruth

09-17-2004 10:20 AM
Oxnard

Andy There are several good works on these subjects, check out Amazon for a few ideas. Can recommend High Performance Oracle by Ingram -- it...

Mark Clark

09-17-2004 10:04 AM
Mark Clark

Hi All I am in a situation where I have to grant select privileges on tables owned by a different owner to a specific role. I am logged in...

Wade Chy

09-16-2004 02:37 PM
Hans Forbrich

Hi All, Just wondering if anybody has any remarks on the query tool from Unity Solutions? I've been testing with it for a while and it seems...

Conner

09-16-2004 10:11 AM
Conner

Hello All. Could you please help us with one issue? We have a table with QTIME TIMESTAMP(9) field and this field is primary key in the table. When...

Dmitry Bond.

09-16-2004 09:53 AM
Jim Kennedy

Hi, I have a basic question on schema changes performed on populated tables. Should I prepare for big roll back area and so on for both of these...

PR

09-16-2004 09:20 AM
PR

Hello All. Currently we are porting some software from NSK (HP Hon-Stop) SQL to Oracle and I faced with the following problem... The SQL...

Dmitry Bond.

09-16-2004 05:58 AM
Dmitry Bond.

Hello, I want to create a generic script that connects to Oracle databases (from 7.3.4 to 9.2 version) with a guest user. This script should return...

F. Biguet

09-16-2004 04:41 AM
F. Biguet

How do I grant all privileges for a schema that has a large number of existing tables, procedures, functions, etc to a newly created role, without...

Ted

09-15-2004 08:41 PM
Bob Murphy

#####Background 1) CRONJOB runs 2 RMAN shell scripts at 3AM backup_begin.sh- export and rman backups report_begin.sh- list rman reports My...

TX-DBA

09-15-2004 11:16 AM
TX-DBA

assume: user a has the table tab_a user b has select-right on the table tab_a an creates the view view_b create view view_b as select * from...

matthias

09-15-2004 10:45 AM
matthias

I guess this is an architecture question. The question is: If I've got two (or more) Oracle databases, when does it make sense to integrate them...

puppet_sock@hotmail.com

09-15-2004 09:50 AM
Yukonkid

No flame wars, please! We're planning a move from a non-relational system to a relational system. Our choices have been narrowed to Oracle and DB2....

Mike

09-14-2004 10:51 PM
Michael D. Long

Federal Government client requires an Oracle 11i specialist for a long-term assignment. Are you and 11i expert (including Purchasing,...

The AIM Group

09-14-2004 04:11 PM
The AIM Group

Hi I am attempting to build a firewire based shared disk subsystem for Oracle RAC 10g. I was wondering if anyone new which chipsets were on the...

bjl

09-14-2004 11:33 AM
bjl

Hello there! I am trying to read from a text file and load a table in ORACLE8i. For example I have the following...

Demetris

09-14-2004 05:19 AM
craig

How do I update the views user_tab_columns and dba_tab_columns? I am using Oracle 9. I am trying to use a select command to find out info about the...

Greg Bailey

09-14-2004 04:32 AM
Greg Bailey

Hi Folks, how to identify 2 different session on same machine, same/nearly same logon time that is running on a oracle server. We have different...

Kamesh

09-13-2004 07:24 PM
Joel Garry

Hello all, I am working on creating an eul gateway for Discoverer. I have the sample scripts and was wondering if anyone has done this. I am...

LC

09-13-2004 07:08 PM
LC

Hi, I need to create a table in Oracle DB using SQL before which I need to check if it exists or not, where the dbuser will have CONNECT...

google_user

09-13-2004 04:27 PM
Wario