| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | Hi,
Is there a way of linking in a table into a DB when the table resides
in another DB across a network?
For example, I have a DB, say myDB.
I'd...
Sashi
|
05-16-2008 10:22 AM
Mark D Powell  | 8 | 23 |
 | | 10.2.0.2 EE, aix5L
had a storm this weekend and power went out to the disk cabinet on our
development machine. I was just informed by our sys admin...
Ben
|
05-16-2008 04:31 AM
Frank van Bortel | 24 | 41 |
| | | 10.2.0.2 EE
How is the sql id of any given sql statement set? I've found that
several of our most frequent sql statements have the same sqlid...
Ben
|
05-14-2008 04:18 PM
fitzjarrell@cox.net | 4 | 25 |
| | | I'm using Oracle 10.r2
There are no triggers on this table when I did a select * from
all_triggers;
Error report:
ORA-04091: table "x" is mutating,...
kes
|
05-13-2008 06:54 PM
kes | 8 | 18 |
| | | Hi,
Here is the date format coming in on the input file: Apr 7 2009
12:00AM
So, if the AM / PM is coded there, how can I put that into the...
Mtek
|
05-13-2008 02:50 PM
Mtek | 8 | 22 |
| | | Hi,
Some one could tel me how can i do to multiplexing redo log ?
how do set into the init.ora file to multiplex redo log ?
Thank's
scratt
|
05-13-2008 10:37 AM
gazzag | 12 | 41 |
| | | Hello,
Need some quick help...
I have an XP-machine with Oracle 10g,
both EE and XE installed as standard "starter databases" with...
grz01
|
05-13-2008 10:15 AM
fitzjarrell@cox.net | 20 | 64 |
| | | Hi all,
I have a query as follows:
Select building, floor from T1
I would like to limit the output where the building, floor combination
is...
Sashi
|
05-12-2008 11:40 AM
Urs Metzger | 16 | 36 |
| | | This simple query is driving me nuts.
I have a simple table:
customer_id
action_date
action
I want to get a distinct count of customer_id where...
amerar@iwc.net
|
05-12-2008 10:57 AM
Urs Metzger | 68 | 248 |
| | | Business Intelligence the Key to Winning at Outsourcing
07/05/2008 12:05:00
Sydney, 7 May 2008 – The ability to report on key business metrics...
Yellowfin
|
05-12-2008 07:25 AM
Yellowfin | 0 | 19 |
| | | Hello everyone,
we are currently migrating a software to use Oracle 10 client (OCI)
instead of Oracle 9. A problem occurs that manifests itself in...
André Hartmann
|
05-11-2008 09:06 AM
Kevin English | 4 | 16 |
| | | This is what I'm doing now... is there a better way?
It would be great if there were some construct such
as 'for i in x begin ... end;'
i :=...
mh@pixar.com
|
05-10-2008 10:08 AM
Mark D Powell | 32 | 63 |
| | | Hi.
We are connecting to an Oracle 9i Database, is it possible to query a
table to find out the last date / time a row was updated /...
alastair.coombs@googlemail.com
|
05-10-2008 10:00 AM
Mark D Powell | 12 | 39 |
| | | Hello All:
I am using 10g.
My goal is to replace PL/SQL cursor FOR LOOPs with a single SQL when
possible. In order to do that, I need to use inline...
General Fear
|
05-09-2008 10:06 AM
Mark D Powell | 4 | 21 |
| | | "Jens Müller" <usenet-11-2007 (AT) tessarakt (DOT) de> schreef in bericht
news:68gehsF2sp00uU1 (AT) mid (DOT) individual.net...
Yes, wrong direction...
Shakespeare
|
05-09-2008 02:40 AM
Shakespeare | 1 | 15 |
| | | We are planning to port a huge application from Informix to Oracle and
it has got tons of SQL statements that need to be converted to make
them...
Murty
|
05-09-2008 01:08 AM
JACKY | 4 | 17 |
| | | Hi Guys,
My database has records with foreign characters at the end of the
string that need to be updated to a '-'.
I have used the following...
christophercash@hotmail.com
|
05-07-2008 12:35 PM
Mark D Powell | 4 | 19 |
| | | I would like to allow developers to kill their own sessions, e.g.
alter system kill session '$sid,$serial#'
but only for sessions which are...
mh@pixar.com
|
05-07-2008 11:47 AM
Mark D Powell | 24 | 47 |
| | | Using 10.2.0.3.0 on solaris, I'm trying to write some tests against
utl_mail.send_attach_varchar2. I receive the email and the
attachments, but the...
neil kodner
|
05-06-2008 05:57 PM
neil kodner | 8 | 27 |
| | | Hi,
This is my query:
SELECT SUM(zcom) + SUM(ze) + SUM(zp)
FROM
(SELECT count(DISTINCT(email)) FROM customers_lookup) zcom
UNION
(SELECT...
Mtek
|
05-06-2008 02:04 AM
Peter Nilsson | 20 | 54 |
| | | Hi,
I have a table that has sample records like below:
Emp No. Unique ID From Date To...
Sandy80
|
05-05-2008 08:39 AM
fitzjarrell@cox.net | 4 | 18 |
| | | I am attempting to use a variable in the WHERE clause of a SELECT statement.
How would one pass a value for an IN statement, ie.
SELECT *
FROM...
okumura-mikiop@jvc-victor.jp
|
05-03-2008 03:22 AM
William Robertson | 8 | 15 |
| | | Are you a proven Project Manager with deep experience in large,
highly-complex software implementation efforts? You are? So, can
you:
* Hold...
David_Parkes
|
05-02-2008 08:56 PM
David_Parkes | 0 | 14 |
| | | I'm working with Oracle 10g R2
create table table1(
table1_id number,
csv1 varchar2(100),
csv2 varchar2(100));
insert into table1 values(1,...
kes
|
05-02-2008 04:28 PM
joel garry | 16 | 31 |
| | | Hi all,
First of all - IANADBA. I'm just a developer / project manager.
Oracle 10.2.0.3 RAC cluster on Intel Linux, ASM on a SAN.
We have a...
Geoff Muldoon
|
05-01-2008 10:35 PM
Geoff Muldoon | 0 | 22 |
| | | I have an Oracle table that has 2 Date fields..i.e. the data type -
DATE
Field 1: START_DATE sample value "2008-04-04 12:00:00";
Field 2: ...
deepakp
|
05-01-2008 04:26 PM
deepakp | 16 | 34 |
| | | Hi,
I have this query:
SELECT...
Mtek
|
04-30-2008 05:42 PM
Robert Klemme | 20 | 49 |
| | | Hi,
I have the following cut down pls/sql:
cur_entries cursorType;
IF condition
open cur_entries for
SELECT a from test_table1 for update of...
Martin
|
04-30-2008 04:49 PM
sybrandb@hccnet.nl | 12 | 35 |
| | | This is what I wish I could to do.
insert into table_x (a, b, c)
values(1, 2, 3)
where not exist (select * from table_x where a = 2);
Thank you.
md
|
04-30-2008 01:01 PM
Ed Prochak | 8 | 20 |
| | | I need to be able to pull just the last name out of a string consisting of
lastname and firstname, separated by a comma, or space, or comma and...
Doug Miller
|
04-29-2008 11:17 PM
Peter Nilsson | 20 | 56 |
| | | Hi,
I have to clone a DB to built a Test DB.
To avoid manual work our admin wrote a script, that in general
- fills some files with file structure
-...
Andreas Mosmann
|
04-29-2008 01:29 PM
joel garry | 48 | 77 |
| | | Hi1
I'd like to create a user that can /only/ connect through a proxy user.
Is this possible?
Right now it seems that any user, proxied or not, needs...
Volker Hetzer
|
04-29-2008 09:53 AM
Volker Hetzer | 0 | 19 |
| | | hi,
we are running oracle 10 on suse linux. when i try to rebuild the
tables i see this message:
"ORA-29400: data cartridge error
ORA-01688: unable...
marton.szabo@ivz.de
|
04-28-2008 02:01 PM
fitzjarrell@cox.net | 4 | 42 |
| | | Hi
I'm teaching myself oracle and I am looking for some easy to follow
step by step tutorials on oracle and sql. I already found a few...
travel2light
|
04-28-2008 07:48 AM
travel2light | 16 | 29 |
| | | PeopleQuest Staffing is currently looking for highly organized multi-
talented Software Programmers with extensive IT experience for our
client in...
coreykeizer@gmail.com
|
04-25-2008 07:00 PM
DA Morgan | 20 | 41 |
| | | Hi all,
My procedure below is failing to provide the desired result and I've
failed to track down what is the cause. The procedure is supposed...
xylem
|
04-25-2008 07:03 AM
xylem | 16 | 37 |
| | | Hello.
We are running Oracle RAC 10.2.0.2 and we received
a note from Oracle to apply CPU 2008 upgrade. However,
this upgrade requires Oracle RAC...
C C
|
04-24-2008 07:29 PM
DA Morgan | 4 | 18 |
| | | We use Oracle RAC 10g on Windows. Everyone seems to complain about the
Windows aspect of it. I am just curious.. is it really a bad mix ?...
F
|
04-24-2008 02:45 PM
mastiff | 16 | 43 |
| | | http://www.youtube.com/watch?v=CHzV4LZnvHc
http://www.youtube.com/watch?v=SNW-7jCBWsw
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University...
DA Morgan
|
04-24-2008 02:15 PM
mastiff | 4 | 22 |
| | | I have an huge application written using C and Pro/C. I want to write C
++ function which will access oracle using OCCI. Can I reuse Pro/C
connection?
dkornyushin@gmail.com
|
04-24-2008 09:09 AM
dkornyushin@gmail.com | 0 | 25 |
| | | Hello NG,
I'm stuck with the following problem and need the help of someone with
more oracle-exp. than me (which isn't that difficult)
Having a...
Alex
|
04-24-2008 04:42 AM
Alex | 8 | 14 |
| | | i am looking to find the first word of a field greater than 17
select businessname
from tablename
where
CHAR(' ', businessname + ' ') > 17
ciojr@yahoo.com
|
04-23-2008 10:58 PM
Peter Nilsson | 4 | 18 |
| | | Hi,
Please take a look at this query:
SELECT max(action_date), customer_id
FROM email_product_hist
WHERE action = 'A'
AND action_date BETWEEN...
Mtek
|
04-23-2008 08:56 AM
Ed Prochak | 4 | 29 |
| | | i have a table with 4 columns, they look like
currency1 currency2 amt1 amt2
=======================
USD GBP 10 9
GBP USD 5 8
JPY ...
Prasath
|
04-23-2008 08:35 AM
Prasath | 0 | 25 |
| | | Hello,
I have a table which has 3 columns: user id, key and value. A user may
only have one instance of a given key. However, the key may...
MountainOaf@gmail.com
|
04-22-2008 10:53 AM
Mark D Powell | 20 | 74 |
| | | Hi,
Has anybody come across any tools/products that can scan the Oracle 7
redo log to identify the data changes and do something with it? Have
you...
suni
|
04-22-2008 10:38 AM
Mark D Powell | 8 | 20 |
| | | Hi,
I have a problem, I found on internet a way to split strings separated
by pipe | (for example) with regexp, something like that:
SELECT...
citte
|
04-22-2008 06:32 AM
citte | 24 | 74 |
| | | Hi,
Is there a way to find out what indexes are used(useful)/unused(useless)
while the last few days/weeks?
If possible so tell me a way via data...
Andreas Mosmann
|
04-21-2008 02:46 PM
joel garry | 52 | 117 |
| | | Dear Friends,
Kindly dont ignore this mail. This is not a spam.
Visit the link to get OCP dumps online absolutely...
GREENLAND
|
04-21-2008 01:25 PM
Mark D Powell | 8 | 29 |
| | | HI,
WE HAVE AN UNRGENT REQUIRMENT OF A SENIOR JAVA CONSULTANT WITH STRONG
UI.
LOCATON: CALIFORNIA BAY AREA
LONG TERM POSITION.
FACE TO FACE...
faisal
|
04-19-2008 07:56 AM
Robert Klemme | 4 | 25 |
