| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | Hi,
I have a Oracle 10g back-end, and an Access 2000 front-end.
One particular page uses OO4O to connect directly to the database. It
opens and...
wrldruler
|
11-06-2007 12:02 PM
wrldruler  | 0 | 66 |
| | | Hello
I have an update trigger that is for each row.
The goal is to detect if a timestamp field is updated, if not updated
it with system...
Menthe&Basilic
|
11-06-2007 10:47 AM
DA Morgan | 1 | 77 |
| | | Hi All,
The sql below does not return anything,
select DTE_SYSDATE
from A_T_PR_TAXONOMY
WHERE DTE_SYSDATE = to_date( 20071031, 'yyyymmdd')
while...
ouyang.jie@gmail.com
|
11-05-2007 03:23 PM
Shakespeare | 5 | 70 |
| | | How to modify dads.conf via console?
Is it possible
Beginner
|
11-05-2007 02:04 PM
Frank van Bortel | 1 | 59 |
| | | Hello!
My shop recently relocated our Oracle 10g instance to a new box.
Since, this action, I can no longer run JSP's from my local host
(Windows...
BikRboy
|
11-05-2007 10:51 AM
BikRboy | 2 | 71 |
| | | http://oracle-programming.blogspot.com
lawry_jim@yahoo.com
|
11-04-2007 03:10 PM
DA Morgan | 1 | 70 |
| | | when do you think ms will have a database based filesystem ?
hilt
|
11-04-2007 11:52 AM | 6 | 117 |
| | | Database version: 9.2.0.6.0
OS = Solaris 8
I currently work for an organisation that continually shoots itself in
the foot with the large amount of...
HectorTYC
|
11-02-2007 04:55 PM
HectorTYC | 4 | 63 |
| | | I have a simple query:
SELECT SUM(cases_escalated) AS casesescalated FROM groupsummary WHERE
report_date=TO_DATE('Sep 2007','MON YYYY') AND...
trpost@gmail.com
|
11-02-2007 09:38 AM
Ken Denny | 4 | 83 |
| | | The task I have is to output some messages from a procedure in a package.
The package is run in a shell script from plsql by piping the output...
Tim B
|
11-02-2007 02:21 AM
William Robertson | 1 | 70 |
| | | I have a simple query:
SELECT SUM(cases_escalated) AS casesescalated FROM groupsummary WHERE
report_date=TO_DATE('Sep 2007','MON YYYY') AND...
trpost@gmail.com
|
11-01-2007 06:21 PM
DA Morgan | 1 | 63 |
| | | I all
I have an 25-years-old experience on Microsoft developing, from sequential
files to MsSQL. Oracle was the inarrivable myth.
Now I am...
spam
|
11-01-2007 02:03 PM
Frank van Bortel | 7 | 70 |
| | | Is it possible to access two different Oracle databases located on
two separate servers within a tool such as Oracle SQL Developer or
PL/SQL...
jjablt@hotmail.com
|
10-31-2007 04:41 PM
joel garry | 5 | 80 |
| | | We seem to have bumped into a common issue, and that is that we need
to automate the loading of a few thousand files nightly.
EXTERNAL TABLEs seem...
Brian Tkatch
|
10-31-2007 09:50 AM
Brian Tkatch | 6 | 123 |
| | | Oracle 9.2
While trying to install the Oracle client on a server, the team got an
error. Searching for this error on google found the following...
Brian Tkatch
|
10-30-2007 08:55 AM
Brian Tkatch | 3 | 68 |
| | | Hi,
I want to register an MBean with the oracle cluster Mbeanserver. I
have no clue, so far, whether its possible or not. I want the bind
the bean...
yogi
|
10-27-2007 10:51 AM
yogi | 0 | 63 |
| | | Hello, I want to replace a portion of a string value in columns in a
table.
Lets say I have a table called TABLE_TEST with something like...
cqmman
|
10-26-2007 07:34 PM
Mark D Powell | 3 | 56 |
| | | I have a problem with reading data from Oracle in Excel. When reading
a
longvarchar, I get nothing - it does not read any data out.
The code (VBA in...
Sonnich Jensen
|
10-26-2007 11:53 AM
DA Morgan | 5 | 70 |
| | | Hi everyone,
I am practice on create trigger in Oracle. I found some simples online
and tried to put it in my computer. However, it pops up an...
Krista
|
10-26-2007 11:51 AM
DA Morgan | 12 | 128 |
| | | What do you recommend for regular database health check in Oracle? We want
to make it as standard procedure. Is it necessary? MSSQL has...
David
|
10-26-2007 11:48 AM
DA Morgan | 4 | 87 |
| | | Can anyone tell me how I can reverse engineer an Oracle database from
Visio Professional 2003?
I am running a Oracle 9 database, just installed the...
Henrootje
|
10-26-2007 09:55 AM
Henrootje | 12 | 119 |
| | | Hi
I have a problem when reading a longvarchar, displays as memo in DB
Explorer. It reads, but when reading in excel it gives an error...
Sonnich Jensen
|
10-26-2007 12:31 AM
jodleren | 5 | 68 |
| | | Hi!
I have one silly question. I want to update an Oracle ODBC-driver for a
MS-Windowssystem. So I downloaded the driver from the oracle...
Markus Misiak
|
10-24-2007 02:58 AM
Markus Misiak | 3 | 85 |
| | | Oracle 9.2
We process a few thousand batches nightly, each with a few hundred
lines, where the data is stored in a TABLE and an UPDATE is...
Brian Tkatch
|
10-23-2007 06:57 PM
joel garry | 6 | 60 |
| | | On 23 oct, 14:08, Björn Wächter <bwc (AT) p3-solutionsKILL_SPAM (DOT) de> wrote:
Analytics rock, analytics roll...
Cheers.
Carlos.
Carlos
|
10-23-2007 12:48 PM
Michel Cadot | 1 | 63 |
 | | Hi Dieter,
Yes. Oracle 9. But I am with you that most modern DBMSs are currently
support the standard. But wouldn´t the standard be much...
roman.morokutti@googlemail.com
|
10-23-2007 05:25 AM
roman.morokutti@googlemail.com | 27 | 165 |
| | | I've searched under dynamic and case sub select, but I am not sure if
what I am asking for can be done in a straight sql query (new to...
kimberly.shaffer@gmail.com
|
10-22-2007 04:56 PM
kimberly.shaffer@gmail.com | 0 | 64 |
| | | Hello,
Can somebody help me resolve following order by problem, I am
running out of ideas.
I have following temp table with following data
CREATE...
m&m
|
10-22-2007 04:51 PM
m&m | 3 | 61 |
| | | Greetings,
We are using Oracle 9i. Are regexp functions available in Oracle 9i, or
was that introduced with 10?
Given the following two...
Fester Bestertester
|
10-22-2007 04:42 PM
Fester Bestertester | 4 | 58 |
| | | hallo !
can me somebody say, how i get from this select statement max date - 7
days.
select max(to_date(substr(PARTITION_NAME,6,10),'dd.mm.yyyy'))...
sansar
|
10-22-2007 04:32 PM
joel garry | 4 | 58 |
| | | Hello,
Does the Oracle Transparent Gateway have the same limitations on BLOB/
CLOB
data that the Oracle Generic Connectivity has? Specifically...
jjablt@hotmail.com
|
10-22-2007 03:53 PM
jjablt@hotmail.com | 0 | 55 |
| | | I would like to make sure there are no duplicate data entries in my
Oracle 9i table (called MainTable) which has an Id field that is the
primary key,...
teser3@hotmail.com
|
10-22-2007 09:44 AM
fitzjarrell@cox.net | 2 | 52 |
| | | I've got this function that tells me when a customer's last few orders
had rejected credit cards transactions in our orders table.
When I run the...
jobs
|
10-21-2007 05:06 AM
William Robertson | 2 | 65 |
| | | Hallo !
I have write a pl/sql-script. but i don't get a solution.
i want add a new partition. And from the new added partition make - 8
to find a old...
sansar
|
10-20-2007 08:50 AM
sansar | 0 | 54 |
| | | create or replace function checkVersion return boolean is
a varchar(1000);
Res boolean;
begin
select version into a from v$instance;
if (a like...
abdoul85
|
10-20-2007 04:11 AM
William Robertson | 3 | 99 |
| | | I have problem:
I want to write data into two files concurrently. spool and
dbms_output.put_line doesn't provide this functionality. Is there...
abdoul85
|
10-19-2007 03:07 AM
DA Morgan | 4 | 44 |
| | | Hi all,
Is it possible to concatenate the columns of the results of a query
without having to run it through an external filter?
For examples, if I...
Sashi
|
10-18-2007 10:16 PM
Sashi | 3 | 50 |
| | | We are currently looking out for a PORTAL DEVELOPER with the following
skills:
Comprehensive knowledge of Oracle Portal Application...
shankar
|
10-18-2007 06:37 PM
shankar | 0 | 48 |
| | | Hallo !
My PL/SQL -Script send me a Error-Message.
I don't know how i find the error.
i want add a new range partition in a existing table...
sansar
|
10-18-2007 11:05 AM
DA Morgan | 8 | 58 |
| | | We have a table, T1, with a range partition on a numeric value. I am
trying to join the dba_tab_partitions table with T1 where high_value...
JonL
|
10-18-2007 09:38 AM
fitzjarrell@cox.net | 2 | 58 |
| | | Hello,
i am working with Oracle 9i on a project where the TABLEs and COLUMNs
conform to some standard, which, IMO, makes the names too tedious...
Brian Tkatch
|
10-17-2007 03:47 PM
DA Morgan | 1 | 55 |
| | | Oracle 9.0.
Is it possible to rename the column of a view? Or is the only way of
doing it is to drop and recreate the view with the new column...
Sashi
|
10-17-2007 11:44 AM
fitzjarrell@cox.net | 2 | 53 |
| | | Hallo !
My PL/SQL -Script send me a Error-Message.
I don't know how i find the error.
i want add a new range partition in a existing table...
sansar
|
10-17-2007 09:46 AM
sansar | 0 | 52 |
| | | hello
I'd like to do sth like this:
declare
a varchar(100);
begin
select version into a from v$instance;
if (a like '10%') then
@ver10.sql
else
abdoul85
|
10-17-2007 02:10 AM
DA Morgan | 5 | 56 |
| | | Hi,
I am trying to implement sending attachments using PL/SQL(java). I
searched the web for the process and I am not succesful in
implementing the...
nickli2000@gmail.com
|
10-17-2007 02:08 AM
DA Morgan | 1 | 51 |
| | | I had installed Oracle 10g client on Windows 2003 Server. Today I
uninstalled it and tried to install 9i client. But setup.exe does not
run. Some...
dn.perl@gmail.com
|
10-16-2007 09:53 PM
dn.perl@gmail.com | 3 | 62 |
| | | Hi Gurus,
Could anyone of you plz send me the documents to understand
complete Oracle Purchasing Module.
Thanks & Regards,
Saritha
sari.oracle@gmail.com
|
10-16-2007 02:39 PM
fitzjarrell@cox.net | 2 | 57 |
| | | Hi,
We created a script ( for sqldeveloper) to do insert data into our db.
When we look at the script on windows it lloks fine. On redhat linux we...
Mikael Petterson
|
10-16-2007 11:25 AM
Laurenz Albe | 1 | 57 |
| | | Hello
The problem is to adding a column to a big IOT table, 23 millions
records, when trying
the simple "add column.." we get too much undo, the DDL...
Nonor
|
10-16-2007 11:05 AM
fitzjarrell@cox.net | 1 | 53 |
| | | I've got this function that works great when I select from it from
dual:
select is_rejecting_fn(2408) from dual
returns 1
but If I attempt to use...
jobs
|
10-16-2007 07:13 AM
Jerome Vitalis | 1 | 51 |
