| | Rating Thread /
Thread Starter | Last Post | Replies | Views |
|  | 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 | 0 | 163 |
|  | 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 | 0 | 182 |
|  | 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 | 2 | 195 |
|  | 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 | 0 | 326 |
|  | 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 | 1 | 215 |
|  | 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 | 0 | 186 |
|  | 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 | 3 | 141 |
|  | 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 | 2 | 367 |
|  | 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 | 3 | 194 |
|  | 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 | 3 | 162 |
|  | 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 | 3 | 181 |
|  | 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 | 0 | 231 |
|  | 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 | 8 | 151 |
|  | 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® | 0 | 137 |
|  | 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 | 0 | 173 |
|  | 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 | 2 | 170 |
|  | 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 | 2 | 159 |
|  | 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 | 0 | 267 |
|  | 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 | 0 | 180 |
|  | 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 | 0 | 188 |
|  | 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 | 1 | 209 |
|  | 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 | 5 | 468 |
|  | 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 | 1 | 242 |
|  | 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 | 15 | 322 |
|  | 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 | 0 | 169 |
|  | 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 | 1 | 282 |
|  | 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 | 5 | 245 |
|  | 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 | 1 | 176 |
|  | **** 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 | 0 | 260 |
|  | 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 | 4 | 165 |
|  | Is this possible in 8 or 9 ?
Does anyone have an example ?
Thanks
David Pylatuk
|
09-29-2004 07:54 PM
Hans Forbrich | 1 | 155 |
|  | 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 | 1 | 210 |
|  | 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 | 5 | 322 |
|  | 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 | 0 | 176 |
|  | 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 | 0 | 136 |
|  | 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 | 0 | 259 |
|  | 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. | 1 | 325 |
|  | 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 | 1 | 206 |
|  | 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 | 0 | 173 |
|  | 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 | 1 | 151 |
|  | (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 | 0 | 142 |
|  | 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 | 1 | 213 |
|  | 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 | 2 | 188 |
|  | 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 | 11 | 323 |
|  | 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 | 14 | 405 |
|  | 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 | 0 | 153 |
|  | 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 | 4 | 145 |
|  | 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 | 0 | 132 |
|  | 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 | 1 | 169 |
|  | 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 | 2 | 154 |