I have only a developer's level knowledge of Oracle, though I have access to DBA tools. Searches through the docs have not been fruitful, so I...

hankr

11-22-2004 03:46 PM
hankr

good day , I'm interesting in the IS design and architecture. If anybody works or worked in the subject area , please , give me such information...

Timur

11-16-2004 10:23 AM
Timur

Hi, Can i delete files in cdump folder. Whats the basic use of having files in cdump folder. Is there any need to take backup when deleting the same....

U C

11-15-2004 08:23 PM
Hari Vetsa

Looking for Oracle DBA with PL/SQL experience for full-time contract position in the Hampton, VA area. Please reply directly to me, I don't usually...

Louis Nardozi

11-15-2004 06:47 PM
Louis Nardozi

Hello When I years ago installed Oracle 7.3 there was a 'native driver' to Borland Delphi 3 (sqlora32.dll and ora73.dll!)! If I today buy and...

Morten Rasmusssen

11-14-2004 05:11 AM
heb@busk.dk

Hello, Does anybody use Oracle 9i for OpenVMS? Do you have to change the logical name: "SYS$TIMEZONE_DIFFERENTIAL" = "3600" twice a year, when the...

Andoni

11-11-2004 01:44 PM
Andoni

I am trying to download Oracle 10g from Oracle's download site and keep getting disk full errors. I am trying to download to my G drive (all...

Richard Kinread

11-08-2004 04:15 PM
Richard Kinread

Hi all. I'm using the Oracle Version 8 client with the database stored on a network machine. Can anyone provide insight into how and where to start...

Gordon Keeler

11-05-2004 11:25 PM
IANAL_VISTA

Hi! I need an PL/SQL that takes number as input and returns an barcode. Solutions? Greeting Bjørn

bdj

11-03-2004 11:14 AM
bdj

I am looking for the PL/SQL equivalent of the VBScript Exec and/or Eval functions, i.e. I want to be able to dynamically create a statement,...

Agoston Bejo

10-31-2004 12:45 PM
GQ

Hi, when a SELECT in an INSERT INTO statement returns no rows, NO_DATA_FOUND exception is raised. How do I write a "nice" SELECT INTO when I expect...

Agoston Bejo

10-28-2004 03:15 PM
Ed prochak

Does anyone have any experience with or recommendations on Oracle's CDROM for OCP DBA Fundamentals I? $600 is a lot to shell out sight...

Frank Luff

10-26-2004 04:51 PM
Frank Luff

Take a look at the following example: table T(i INTEGER, j INTEGER) I want to get the value of i where j is minimal and some conditions...

Agoston Bejo

10-20-2004 04:21 PM
Holger Baer

Hi all, Just wondering if it is possible to compare against multiple values _with_ pattern matching? Example: SELECT * FROM dog WHERE NAME LIKE...

Clouds®

10-20-2004 03:32 AM
Clouds®

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